The cell for your total time should be formated to this.

FORMAT / CELLS / CUSTOM

[HH]:MM

This will keep the hours from rolling over at the 24th hour.

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=391565