Timesheet, overtime with daytime from 7:30am to 16:30pm

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

Guest

I´m trying to make a timesheet, so far I have total hours but the daytime
hours are from 7:30am to 16:30pm. Is there a formula that counts the hours
worked within this time and put´s that number in one cell and puts extra
hours in another cell.
I know that this might be hard to find out, couse I want to have it easy for
me to use, it would be best if I could enter the starttime and endtime for
each day and excel would calculate the rest.
 
Let's says
Start time in A1, end time in B1, regular hours in C1, and OT hours in D1

Regular hours
C1 =MIN((B1-A1)*24,8)

OT hours
D1 =MAX(0,(B1-A1)*24-8)
 
I tried the max formula and if endtime is less then 16:30 then I get a
negativ number, howerver I did not have *24-8
And also what will the outcome be if starttime is 8:00 with this formula?
 
You must log in or register to reply here.

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

Timesheet Overtime Calulations - Excel 2002 5
How do I sum up a column hours, like 9:30am - 5:30pm, in Excel? 5
Timesheet with many conditions 4
#VALUE error add'g formulas 1
Need help with a timesheet formula 1
CONVERT HOURS AND MINUTES TO INT 3
figure out why this formula isn't calculating correctly 9
Creating automated timesheets 2

Back
Top