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