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