| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help working with time
For example, I have a cell that is formatted [h]:mm and indicates 50:03 (50
hours 3 minutes) and I need to convert it to days, hours, minutes. Is there a formula I can use? I tried dividing by 24 but my answer was 2:05 using the [h]:mm format but if I use General or Number formating I get 0.08689. Thanks for your assistance. -- Constance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time formula | Excel Discussion (Misc queries) | |||
| How do I write an Excel formula to calculate my working time? | Excel Worksheet Functions | |||
| Logic formula using Time | Excel Discussion (Misc queries) | |||
| Formula for a time card | Excel Worksheet Functions | |||
| What is the formula to display a negative time results? | Excel Worksheet Functions | |||
Threaded Mode
