| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format time in decimal format & calculate time
I used the CUSTOM function as [mm:ss], but it's not working as I thought that
it would. What I want is a user to type in the number of dictated minutes they typed for a job; i.e: 2:30 (2 min. 30 sec) and have it stay in that format as decimal after entered. However, I'm getting results of 12:00 for that example when using the format stated above? I also want to add these dictated minutes and have the result calculated in H:MM:SS. HELP? I've tried everything! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate | Excel Discussion (Misc queries) | |||
| Decimal to Time Format. | Excel Worksheet Functions | |||
Hybrid Mode
