Sum Up data in Time Format

[Indra]

Hi There,

I have set data below, and I need to sum up the data so can be appears as total hours, minutes and seconds, instead of below. Any help would be appreciated, as ussual.

regards,

Indra

Total Hours
--------------------------
Day 1 9:00:00
Day 2 11:00:00
Day 3 5:00:00
--------------------------
Total 1:00:00
--------------------------

[Leif]

Try formatting the Total cell with with the custom format: [h]:mm:ss

x.jpg

[Indra]

Thank you Leif,

this is cool.

regards
Indra

[Sundog]

Try formatting the Total cell with with the custom format: [h]:mm:ss

Lief, when custom formatting, what do the [square brackets] do, in general?

[Don Wells]

Try formatting the Total cell with with the custom format: [h]:mm:ss

Lief, when custom formatting, what do the [square brackets] do, in general?

Does this help?

[Leif]

Lief, when custom formatting, what do the [square brackets] do, in general?

(Thanks Don!)

My understanding is that Excel stores time in Days, therefore once you get to 24, the hours counter resets to 0.
(e.g. 3:00:00 + 21:00:00 = (1 day plus) 00:00:00)

The [h] forces the time to be displayed in hours without being converted into days - [hh] would force the hours to be shown with a leading zero if required.

You'll find a whole bundle of information on formatting dates and times at Date & Time.

[sdckapr]

The [h] forces the time to be displayed in hours without being converted into days - [hh] would force the hours to be shown with a leading zero if required.

And also [m] ([mm]) and ([ss]) keep elapsed minutes and seconds, respectively without "re-countering" to 0 so the values can be higher than 59.

Steve

PS: But it has nothing to do with storing date/time in units of days. It would still need some distinction with the hour/min/sec of "time on a clock" vs elapsed hours/min/sec even if the stored units were hours, minutes, seconds or whatever...

[Leif]

Steve - thanks for the clarification

[Sundog]

Thanks, Don, Lief, and Steve!

You'll find a whole bundle of information on formatting dates and times at Date & Time.

Wholly Toledo! What a great link!! Thanks, Lief!!!