Calculating Elapsed Time from total seconds

BobSullivan
3StarLounger
Posts: 235
Joined: 08 Jun 2010, 20:03
Location: Morgantown, PA

Calculating Elapsed Time from total seconds

Post by BobSullivan »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Calculating Elapsed Time from total seconds

Post by HansV »

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:
S0745.png
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

BobSullivan
3StarLounger
Posts: 235
Joined: 08 Jun 2010, 20:03
Location: Morgantown, PA

Re: Calculating Elapsed Time from total seconds

Post by BobSullivan »

Thanks! That's a lot easier than the crazy formula I was building.
Cordially,

Bob Sullivan
Elverson, PA