Col A = Start Time
Col B = End Time
Col C = Elapsed Time

A3 =9:43
B3 =17:12
C3 =B3-A3

C20 =SUM(C3:C19)*24

Select Cell C20 and Format Cells General

If start time is before midnight and end time is after midnight:

e.g. end time is 2:00 a.m.
enter end time as 26:00


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=544958