Thread
:
Time Format.
View Single Post
#
3
June 2nd, 2010, 09:16 PM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
Posts: 8,714
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
David Biddulph
View Public Profile
View message headers
Find all posts by David Biddulph
Find all threads started by David Biddulph