Time Conversion issue
First of all what you have not only hours but also one day, one hour and 45
minutes
if you day/hour/minute is in A1 use this
=MOD(A1,1)/60
format as mm:ss or [mm]:ss if your minutes will be greater than 59:59
and copy down. Copy and paste special as values to make them static
For future entries enter a minute like 00:01:00
--
Regards,
Peo Sjoblom
"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.
|