From: GEM on
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
From: Bob Phillips on
Use

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

and format it as h:mm:ss

--

HTH

Bob

"GEM" <GEM(a)discussions.microsoft.com> wrote in message
news:072EE4E4-9BE0-4835-B246-79D1F4DFE977(a)microsoft.com...
>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


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


"GEM" <GEM(a)discussions.microsoft.com> wrote in message
news:072EE4E4-9BE0-4835-B246-79D1F4DFE977(a)microsoft.com...
> 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