HLookup and how it works

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Offsetting and HLOOKUP 5
Time Sheet Summary 1
Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
How do I convert time to the nearest 1/4 hour with a 7 min. window 4
Timecard functions and formulas 1
HLOOKUP copied across rows with "row index number" changing 3
Figuring time worked, and then separating it into regular time an. 6

Back
Top