Time Conversion issue
25:45 is 1 day (24 hours) + 1 hour 45 minutes.
If you want to lose the complete days, use =MOD(A2,1) and that will turn it
from 25:45 to 1:45.
If you then want to re-interpret from hours and minutes to minutes and
seconds, you can then divide by 60, so =MOD(A2,1)/60 should give you
00:01:45
--
David Biddulph
"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.
|