formulas for employee time sheets

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

Guest

I am trying to create an Employee Time Sheet that has running totals of hours
and calculates those running totals at an hourly wage. This part, I have
created. The part I am having trouble with is entering formulas that will
calculate overtime rates once 40+ hours is reached.
 
If you have the total hours in C2 this formula will give the overtime

=MAX(C2-40,0)

if the total hours are not decimal hours but excel hours and you want the OT
in Excel hours

=MAX(C2-40/24,0)

formatted as time

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Daily Time Sheets with Rounding 1
overtime calculation 3
Trying to calculate hours worked on timecard using "IF" command 6
Formula to sum based on a change in another column 2
new to excel need help with function 4
Timecard functions and formulas 1
Calculating regular time, subtracting any personal time 5
Time Sheet Summary 1

Back
Top