Enter the times in "h:mm" format,
viz. input in A1:A7 as:

2:07
0:30
0:35
1:10
0:10
0:59
0:15

Then just sum it up in A8: =SUM(A1:A7)
Format A8 as Custom, Type: [h]:mm
(with the square brackets around the "h")
to enable it to rollover 24 hours, if necess.

For the sample data, A8 will return: 5:46
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JR" wrote:
Example: 2 hrs 7 min plus 30 min plus 35 min plus 1 hr 10 min plus 10 min
plus 59 min plus 15 min??? I know the answer is 5 hours and 46 min but how
can I get excel to give me this answer?