| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert part of decimal to time (minutes only)
For example I have 39:83. I want to convert to 39:49
I want to only convert the :83 decimal into minutes. I am using the =text(value/24, "h:mm") but this is converting 39:83 to 13.49. Please can anyone help ? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert hours format to decimal or minutes (exp. 1:15:00 = 75 min. | Excel Worksheet Functions | |||
| Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
| Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal | Excel Discussion (Misc queries) | |||
| How do i convert angles from degrees,minutes, seconds to decimal | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
