Calculating Elapsed Time from total seconds
-
- 3StarLounger
- Posts: 235
- Joined: 08 Jun 2010, 20:03
- Location: Morgantown, PA
Calculating Elapsed Time from total seconds
I have a number of seconds, like 91003. I would like to know the elapsed time of this figure in hours, minutes, and seconds.
Cordially,
Bob Sullivan
Elverson, PA
Bob Sullivan
Elverson, PA
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Calculating Elapsed Time from total seconds
Let's say the number of seconds is in A1.
In another cell, say B1, enter the formula =A1/86400
86400 is the number of seconds in 1 day.
You'll now see a number such as 1.053275.
Set the number format of the cell with the formula to the Time format 37:30:55 as in the screenshot below:
Or equivalently to the custom number format [h]:mm:ss
You'll now see a time such as 25:16:43.
In another cell, say B1, enter the formula =A1/86400
86400 is the number of seconds in 1 day.
You'll now see a number such as 1.053275.
Set the number format of the cell with the formula to the Time format 37:30:55 as in the screenshot below:
Or equivalently to the custom number format [h]:mm:ss
You'll now see a time such as 25:16:43.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 235
- Joined: 08 Jun 2010, 20:03
- Location: Morgantown, PA
Re: Calculating Elapsed Time from total seconds
Thanks! That's a lot easier than the crazy formula I was building.
Cordially,
Bob Sullivan
Elverson, PA
Bob Sullivan
Elverson, PA