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