Thread: Time Format.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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