Convert seconds to time display HH:MM:SS

joe77 · Mar 19th, 2002, 08:00 AM

Is there any relativley easy way to take a number of seconds, say 105499, and convert it to HH:MM:SS? I know the answer is 29:18:19, but the report generator I use exports in seconds only, and I need HH:MM:SS.

y2k · Mar 19th, 2002, 08:06 AM

Format the cell that contains the value as hh:mm:ss by choosing format cells and choosing custom from the list ont he left. On the right, choose hh:mm:ss. I don't think I've explained myself very well so I hope you know what I mean?????

Dave Hawley · Mar 19th, 2002, 08:08 AM

Hi Joe

If your seconds are C1 use:

=C2/(1440*60)

And custom format as [h]:mm:ss

joe77 · Mar 19th, 2002, 08:08 AM

Actually, that was one of the first things I tried, and it just returns 00:00:00.

Asala42 · Mar 19th, 2002, 08:10 AM

Hiya,

Step 1: Divide your seconds by 86400 (easiest way might be to copy a cell with 86400 and then hit paste specialdivide over your range).

Step 2: Format CellsTime and you'll want to use the "37:30:55" choice. The custom format "hh:mm:ss" will only recycle numbers over 24 hours. I'm sure there's a custom format you could also choose, but the above is already in the listings for time anyway.

Hope that helps,
Adam S.

Dave Hawley · Mar 19th, 2002, 08:12 AM

Quote:

On 2002-03-19 07:08, joe77 wrote:
Actually, that was one of the first things I tried, and it just returns 00:00:00.

Joe:

=C2/(1440*60)

And custom format as [h]:mm:ss

Does work.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 08:00 AM	#1
joe77 New Member Join Date: Mar 2002 Posts: 9	Is there any relativley easy way to take a number of seconds, say 105499, and convert it to HH:MM:SS? I know the answer is 29:18:19, but the report generator I use exports in seconds only, and I need HH:MM:SS.

Mar 19th, 2002, 08:06 AM	#2
y2k Board Regular Join Date: Feb 2002 Location: Ireland Posts: 133	Format the cell that contains the value as hh:mm:ss by choosing format cells and choosing custom from the list ont he left. On the right, choose hh:mm:ss. I don't think I've explained myself very well so I hope you know what I mean?????

Mar 19th, 2002, 08:08 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Joe If your seconds are C1 use: =C2/(1440*60) And custom format as [h]:mm:ss

Mar 19th, 2002, 08:10 AM	#5
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hiya, Step 1: Divide your seconds by 86400 (easiest way might be to copy a cell with 86400 and then hit paste specialdivide over your range). Step 2: Format CellsTime and you'll want to use the "37:30:55" choice. The custom format "hh:mm:ss" will only recycle numbers over 24 hours. I'm sure there's a custom format you could also choose, but the above is already in the listings for time anyway. Hope that helps, Adam S.