| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Division Question
I'm trying to figure out how to take the total time and then divide it by
60minues. right now I have a number such as 0:27:20, which is in cell a2, and I want to be able to divide it by 60. The formula I am using is =a2/time(0,60,0). I don't know if I'm not getting the right answer. It comes up with 56:00. Can someone help me. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Elapsed time question | Excel Discussion (Misc queries) | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| conditional formatting with time values | Excel Discussion (Misc queries) | |||
| Time Question...is this possible? | Excel Discussion (Misc queries) | |||
| rounding time question | Excel Worksheet Functions | |||
Threaded Mode
