HLookup and how it works

M

Marjolyn Noble

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
 
B

Biff

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
 
Top