HLookup and how it works
 

I am currently designing a timesheet template so that it will automatically
dissect total hours worked into Ordindary Hours (max 7.6hr per day, Time&Half
next 3 hrs, and the balance will be Double time). I'm not sure which would be
the best function to assist. I have used the=IF function but there are
flaws. Can anyone suggest which function woulb be more appropraite? Thanks

HLookup and how it works
 

Hi!

A2 = hours worked for the day

B2 = Ordindary Hours:

=MIN(ISNUMBER(A2)*A2,7.6)

C2 = Time&Half:

=MIN(3,A2-B2)

D2 = Double time:

=A2-B2-C2

Biff

"Marjolyn Noble" <Marjolyn wrote in message
...
I am currently designing a timesheet template so that it will automatically
dissect total hours worked into Ordindary Hours (max 7.6hr per day,
Time&Half
next 3 hrs, and the balance will be Double time). I'm not sure which would
be
the best function to assist. I have used the=IF function but there are
flaws. Can anyone suggest which function woulb be more appropraite?
Thanks