Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Conversion issue
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date conversion issue | Excel Discussion (Misc queries) | |||
'03 UDF conversion to '07 encryption issue | Excel Worksheet Functions | |||
Excel time conversion issue | Excel Discussion (Misc queries) | |||
XML to Excel conversion issue | Excel Discussion (Misc queries) | |||
Date conversion issue... again | Excel Discussion (Misc queries) |