ExcelBanter - Time Format.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time Format. (https://www.excelbanter.com/excel-discussion-misc-queries/265085-time-format.html)

GEM

Time Format.

I have a column with numbers that represent seconds, for example 109.

How can I change this number (109) to this format, 0:01:49

Bob Phillips[_4_]

Time Format.

Use

=TIME(0,INT(I1/60),MOD(I1,60))

and format it as h:mm:ss

--

HTH

Bob

"GEM" wrote in message
...
I have a column with numbers that represent seconds, for example 109.

How can I change this number (109) to this format, 0:01:49

David Biddulph[_2_]

Time Format.

=A1/(24*60*60) and format as [h]:mm:ss
--
David Biddulph

"GEM" wrote in message
...
I have a column with numbers that represent seconds, for example 109.

How can I change this number (109) to this format, 0:01:49

All times are GMT +1. The time now is 10:39 PM.