Time Format.
in [General]
|
From: GEM on 2 Jun 2010 13:53 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 2 Jun 2010 14:00 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 2 Jun 2010 16:16 =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
|
Pages: 1 Prev: Infestation of fax machines Next: Pivot Table with MS Access as DataSource |