Enter the values as TIME:

12:00
1:30

=SUM(A1:A2) = 13:30

Format the total as [h]:mm

--
Biff
Microsoft Excel MVP


"Lise" wrote in message
...
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