=MOD(end-start,1)


will take care of hours after midnight

start 18:00
end 04:00


where A1 holds 18:00 and B1 04:00

=MOD(B1-A1,1)

returns 10:00

--
Regards,

Peo Sjoblom

(No private emails please)


"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