sample 1
typed in time without typing the semi colon

0:00
0:00
0:00
0:00
0:00
0:00
0:00

0:00 Total Sample 1


sample 2
typed in time using the semi colon

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

3:17 Total Sample 2



"David Biddulph" wrote:

It should work, so I guess that you've got at least one of your data values
wrong.

It may be easier for us to help you if you tell us what answer you get.
--
David Biddulph

"JR" wrote in message
...
I used the custom format "h:mm" in the cells where I put the times and when
I
type in the numbers it turns to 0:00...and then I typed it in as 2:07 etc
and
formated the cell for where the total is to be to "[h]":mm and it returns
a
different answer than 5:46??? What am I doing wrong?

"Max" wrote:

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?