Chris,

Format all the cells you intend to use as time format in the following
manner:

[hh]:mm

To do this pull down Format/Cells/Custom and enter into the TYPE box
the format above INCLUDE THE SQUARE BRACKETS AROUND THE HH

This will express all time as hours regardless of whether it is less
than 24 hours or not

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=398511