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

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

You could create formulae to work on numbers instead of time, but changing
the team working is the right way to go.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Lise" wrote in message
...

Thanks all - I'll just have to convert the team to all use the one way :-)


"pdberger" wrote:

Lise --

You're mixing units -- 90 minutes is not 0.90 hours, it's 1.5 hours. If
you
format the cells to hh:mm, and enter the times as 12:00 and 1:30, you'll
get
the answer you want.

HTH

"Lise" wrote:

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