Adding time

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

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?
 
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
 
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
 
Back
Top