Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time calculation or formula
Hi - very thick question I'm sure but is driving me mad - I have the
following and want the time to travel in minutes, how do I then calculate the total cell to show hours & minutes ie: 12 hour shift and 90 minute travel = 13 hours and 30 minutes not 12.90?? Any assistance as always appreciated Mon Length of Shift Day 12.00 Length of Shift Night Overtime Travel time to & From work 0.90 Total 12.90 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question calculation time and Index formula | Excel Worksheet Functions | |||
create time calculation formula | Excel Discussion (Misc queries) | |||
formula date and time calculation | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
Time Calculation Formula! | Excel Discussion (Misc queries) |