Thread
:
Time Format.
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bob Phillips[_4_]
external usenet poster
Posts: 834
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
Reply With Quote
Bob Phillips[_4_]
View Public Profile
Find all posts by Bob Phillips[_4_]