View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lise Lise is offline
external usenet poster
 
Posts: 102
Default 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