| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert decimal numbers to time format
Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into hh:mm in next cell, since the rest of the spreadsheet is in that format. Can anyone help please? Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you convert Arabic numbers to English text format? | Excel Discussion (Misc queries) | |||
| Convert time format to a decimal | Excel Worksheet Functions | |||
| How can I change time format to decimal without losing hours? | Excel Discussion (Misc queries) | |||
| Convert degree from decimal number to the standard format (degre. | Excel Discussion (Misc queries) | |||
| Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
Threaded Mode
