Time calculation as percentage SOLVED

iskender · General User Joined: 27 Jul 2007 Posts: 21

I am trying to work out a time calculation spreadsheet for my employees: eg. if a worker clocks in at 16:00 (in A1)and leaves at 23:15 (in A2), I need the formula that would give me 7.25 (as a percentage) in hours in A3. It's a pretty basic formula, I should imagine, but havent been able to find any help till now on the web.
Thanks

bobban · Posted: Fri Oct 31, 2008 5:28 am Post subject:

If you mean as a percentage of 24 hours, so that 7.25 = 30.21%, try the following:

A1 = 16:00 (cell format as Time)
A2 = 23:15 (cell format as Time)
A3 = A2-A1 (cell format as Percentage)
_________________
nil sine labore

iskender · General User Joined: 27 Jul 2007 Posts: 21

Sorry, maybe I was a little unprecise. I just need the minutes as a percentage i.e 15 minutes =0,25. The hours should remain in hours.

bobban · Posted: Fri Oct 31, 2008 6:23 am Post subject:

Ahhhh ok, in that case:

A1 = 16:00 (cell format as Time)
A2 = 23:15 (cell format as Time)
A3 = HOUR(A2-A1)+(MINUTE((A2-A1))/60) (cell format as Number with decimals)
_________________
nil sine labore

iskender · General User Joined: 27 Jul 2007 Posts: 21

Thanks! Very much appreciated.

bobban · Posted: Fri Oct 31, 2008 7:17 am Post subject:

Welcome, please add [SOLVED] to the thread title.
_________________
nil sine labore