| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal to time
i want to know how to change the decimal to time format.
eg: when i enter the time as 9.30 i want that to be changed as 9:30 and also when i enter the time as 1.38 to be changed as 13:38 Thnak you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert time into decimal with max function | Excel Discussion (Misc queries) | |||
| convert time into decimal with max function | Excel Discussion (Misc queries) | |||
| How to convert time to decimal | New Users to Excel | |||
| How do I convert time (38:30) to decimal (38.5) format? | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
