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

Time calculation or formula
 

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

Time calculation or formula
 

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