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
--------------------------
Sum Up data in Time Format
-
- StarLounger
- Posts: 96
- Joined: 03 Sep 2010, 09:17
- Location: Citra Gran, Jakarta
-
- Administrator
- Posts: 7210
- Joined: 15 Jan 2010, 22:52
- Location: Middle of England
Re: Sum Up data in Time Format
Try formatting the Total cell with with the custom format: [h]:mm:ss
You do not have the required permissions to view the files attached to this post.
Leif
-
- StarLounger
- Posts: 96
- Joined: 03 Sep 2010, 09:17
- Location: Citra Gran, Jakarta
Re: Sum Up data in Time Format
Thank you Leif,
this is cool.
regards
Indra
this is cool.
regards
Indra
-
- 5StarLounger
- Posts: 704
- Joined: 28 Jan 2010, 22:47
- Location: Alien Country (Roswell NM)
Re: Sum Up data in Time Format
Lief, when custom formatting, what do the [square brackets] do, in general?Leif wrote:Try formatting the Total cell with with the custom format: [h]:mm:ss
Sundog
-
- 5StarLounger
- Posts: 689
- Joined: 27 Jan 2010, 16:45
- Location: Ottawa, Ontario, Canada
Re: Sum Up data in Time Format
Does this help?Sundog wrote:Lief, when custom formatting, what do the [square brackets] do, in general?Leif wrote:Try formatting the Total cell with with the custom format: [h]:mm:ss
You do not have the required permissions to view the files attached to this post.
Regards
Don
Don
-
- Administrator
- Posts: 7210
- Joined: 15 Jan 2010, 22:52
- Location: Middle of England
Re: Sum Up data in Time Format
(Thanks Don!)Sundog wrote:Lief, when custom formatting, what do the [square brackets] do, in general?
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.
Leif
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Sum Up data in Time Format
And also [m] ([mm]) andThe [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.
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...
-
- Administrator
- Posts: 7210
- Joined: 15 Jan 2010, 22:52
- Location: Middle of England
-
- 5StarLounger
- Posts: 704
- Joined: 28 Jan 2010, 22:47
- Location: Alien Country (Roswell NM)
Re: Sum Up data in Time Format
Thanks, Don, Lief, and Steve!
Wholly Toledo! What a great link!! Thanks, Lief!!!Leif wrote:You'll find a whole bundle of information on formatting dates and times at Date & Time.
Sundog