How to seperate OT and Reg. Hours from total hours

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

Guest

I am setting up an employee spread sheet for tracking and billing hours
worked. What I would like to do is enter the total daily hours an employee
works and have Excel seperate and quantify both regular hours and OT hours.
What function can I use to sum daily hours equal to or less than 8 hours, and
sum everything over 8 hours seperately.
 
cmc1111, have a look here for timesheet examples, there is also some or
links at the bottom, may even find one you can use :)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
If your daily totals are in H2:H8 in time format this formula will giv
you overtime

=SUMPRODUCT(--(H2:H8-"8:00"),--(H2:H8>"08:00"+0))

formatted as [h]:mm

then for regular hours, if the above formula is in H10

=SUM(H2:H8)-H1
 
Would have helped if I had put in the link :(

It was the same as Gord's

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Thank you for your help.

If I would like to enter in daily hours worked over a five day work week and
have Excel seperate and sum the Regular hours and OT hours, how can I do that?
 

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

Adding up total hours worked on employee schedule using various criteria 0
if then formula for total time ;overtime hours versus regular 1
Converting Millitary Time to Hours worked and OT hours 3
Formulas--NEED HELP! 4
Hours and sum of hours 2
Total Working hours If 2
Daily Time Sheets with Rounding 1
need help with formula 3

Back
Top