| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a simple formula to convert time in hundredths to minute
I get an exported excel file that has the time in hours/hundredths and I have
to convert it to hours/minutes - example 6.18 = 6:11, 6.15 = 6:09, etc. I'm doing the conversion but it takes me about 4 passes - is there a simple way to convert this kind of time. Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to convert 15 minute to hourly data | New Users to Excel | |||
| enter time in simple text and convert to hours/minutes | Excel Discussion (Misc queries) | |||
| How to convert an elapsed time in minutes to Days hours and minute | Excel Discussion (Misc queries) | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| Formatting Time with Hundredths of Seconds | Excel Worksheet Functions | |||
Threaded Mode
