Thread
:
Time Conversion issue
View Single Post
#
5
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Time Conversion issue
Enter 60 in an unused cell then copy and Paste Special Divide into the
cell, or cells, that you want to change. Finally reformat the cell as mm:ss
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Farias" wrote in message
...
Hi,
I have a Excel file with time values in a number of columns. The times
are
in hh:mm (01:45) format but should be in mm:ss (01:45) format.
If i change the cell format to [hh]:mm:ss I get 25:45:00.
I divided by 60 and then changed the cell format to mm:ss but got 25:45,
also tried to divide it by 24 first to try to have only 1:45:00 but
instead I
get 01:04:23
I hope this makes sence.
Thanks for your help.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann