Weekly Regular And Ot Formulas

  • Thread starter Thread starter ypeck
  • Start date Start date
Y

ypeck

I need to create a formula to roll ver the hours over 40 to the O
calculation
Sometimes I work six days a week and when accrued more than 40 hour
those hours should be calculated as overtime.

=SUM(I12:I18) this is for the regular hous
=SUM(J12:J18) THIS IS FOR THE OVERTIM
 
Hi ypeck,

I don't really understand your example but assuming that you have something
like:
(Simplified example)

Start time in G12
Finish time in H12

then in I12 enter the formula:
=MIN(H12-G12,TIME(8,0,0))
to give the working time of 8 hours or under and in J12 the formula:
=MAX(H12-G12-TIME(8,0,),0)
to give the time over 8 hours for that day

Now you can sum column I for normal hours and column J for overtime hours.

Have a look at the folowing sites for more information of time sheets:

http://www.cpearson.com/excel/overtime.htm

http://j-walk.com/ss/excel/files/timesht.htm

HTH

Sandy
 
This will work if the situation is that any day you work over 8 hours you get
paid OT, but in situations where it is a weekly total not a daily total that
determines the OT, the example you gave will not work




: Hi ypeck,
:
: I don't really understand your example but assuming that you have something
: like:
: (Simplified example)
:
: Start time in G12
: Finish time in H12
:
: then in I12 enter the formula:
: =MIN(H12-G12,TIME(8,0,0))
: to give the working time of 8 hours or under and in J12 the formula:
: =MAX(H12-G12-TIME(8,0,),0)
: to give the time over 8 hours for that day
:
: Now you can sum column I for normal hours and column J for overtime hours.
:
: Have a look at the folowing sites for more information of time sheets:
:
: http://www.cpearson.com/excel/overtime.htm
:
: http://j-walk.com/ss/excel/files/timesht.htm
:
: HTH
:
: Sandy
: --
: to e-mail direct replace @mailintor.com with @tiscali.co.uk
:
:
: : >
: > I need to create a formula to roll ver the hours over 40 to the OT
: > calculation
: > Sometimes I work six days a week and when accrued more than 40 hours
: > those hours should be calculated as overtime.
: >
: > =SUM(I12:I18) this is for the regular hous
: > =SUM(J12:J18) THIS IS FOR THE OVERTIME
: >
: >
: > --
: > ypeck
: > ------------------------------------------------------------------------
: > ypeck's Profile:
: http://www.excelforum.com/member.php?action=getinfo&userid=16220
: > View this thread: http://www.excelforum.com/showthread.php?threadid=276333
: >
:
:
 
Back
Top