Adding time
 

If I have the time listed to do different jobs in minutes and seconds and I
want to total them, what formatting do I use?

Adding time
 

If A1 displays 2:25 and B1 displays 4:55, then the formula =A1+B1 in C1 will
result in 7:20
Actually, Excel thinks you mean 2 hours, 25 mins, 0 seconds so C1 needs to
be formatted the same as A1 and B1 (h:mm)

To be precise you need 0:2:25 and 0:4:55
If hours exceed 24 you need forma [h]:mm:ss

Tell us what you have tried and what problems you have hit on
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Liz" wrote in message
...
If I have the time listed to do different jobs in minutes and seconds and
I
want to total them, what formatting do I use?

Adding time
 

If you want the answer to be in minutes & seconds, use [m]:ss as the format
for the answer cell. If you want hours, minutes, & seconds, use [h]:mm:ss
It doesn't matter which of the Excel time formats you use for display in the
input cells, as format affects only the display, not the underlying value.
Remember when you are inputting your data that 12:34 will be interpreted as
hh:mm, not mm:ss
You'll need 0:12:34 or 12:34.0 to get it to recognise the time as mm:ss
--
David Biddulph

"Liz" wrote in message
...
If I have the time listed to do different jobs in minutes and seconds and
I
want to total them, what formatting do I use?