View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets
 
Posts: n/a
Default help with calculating overtime in a time sheet

Hi

Start time: A2=23:00
End time : B2= 3:00
Working hours: C2=B2-A2+(B2<A2)
C2 returns 4:00 (the formula returns right time intervall, until it remains
<24:00 - whenever end time < start time, midnight rollover is counted)


Arvi Laanemets


"confused" wrote in message
...
am havint the same problem .but use a 48he clock to overcome it for now

so i enter the time as 23:00 to 27:00

excell does not like working out "night hours" so without over inflating

the
workbook with excessive formulas this works


"jongyrocka" wrote:


hmm...not sure...
either way, i have to include it into the formula's that Russle Govier
posted


--
jongyrocka
------------------------------------------------------------------------
jongyrocka's Profile:

http://www.excelforum.com/member.php...o&userid=27200
View this thread:

http://www.excelforum.com/showthread...hreadid=467159