View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
squeeky
 
Posts: n/a
Default Excel, how do you add times with minutes more than 60

How do you add numbers that are not in time format? They are not in time
format as it is for addition purposes only i.e. If I worked 7 hours 1 day and
7.85 hours the next it should read 15.15 hours and minutes in total.
If using the time format it will read the results as time i.e. 15:15 in the
afternoon, this is the wrong result.

Any ideas?