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
|