Convert seconds to hh:mm:ss.dd ?
 

Could someone help me derive a formula that will turn a column of
seconds and decimals into hours, mins, secs, decimals please. For
example:

Original New
-------- ---------
92.16 00:01:32.16
3987.65 01:06:27.65

I can get there with several columns, and I suppose I could manipulate
these and get them into a single column, but I'm sure there must be a
more elegant solution?

--
Terry, West Sussex, UK

Convert seconds to hh:mm:ss.dd ?
 

=A1/(24*60*60)
and format as:

Custom [h]:mm:ss.00
--
Gary''s Student - gsnu200732


"Terry Pinnell" wrote:

Could someone help me derive a formula that will turn a column of
seconds and decimals into hours, mins, secs, decimals please. For
example:

Original New
-------- ---------
92.16 00:01:32.16
3987.65 01:06:27.65

I can get there with several columns, and I suppose I could manipulate
these and get them into a single column, but I'm sure there must be a
more elegant solution?

--
Terry, West Sussex, UK

Convert seconds to hh:mm:ss.dd ?
 

How about using a helper cell with a formula:
=A1/60/60/24
and give that cell a custom format: hh:mm:ss.000



Terry Pinnell wrote:

Could someone help me derive a formula that will turn a column of
seconds and decimals into hours, mins, secs, decimals please. For
example:

Original New
-------- ---------
92.16 00:01:32.16
3987.65 01:06:27.65

I can get there with several columns, and I suppose I could manipulate
these and get them into a single column, but I'm sure there must be a
more elegant solution?

--
Terry, West Sussex, UK

--

Dave Peterson

Convert seconds to hh:mm:ss.dd ?
 

Gary''s Student wrote:

=A1/(24*60*60)
and format as:

Custom [h]:mm:ss.00

Thanks both!

--
Terry, West Sussex, UK