If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need help w/formula for calculating overtime hours
i am trying to create a timesheet that calculates cells automatically when
data is entered. I am entering time "in" and "out" two times (first half of day total, then second half of day total, after meal break) and then i have a formula which calculates those totals. In algebraic terms, say: a+b=c, then for the second half of the day: d+e=f. then c+f=h, to give total hours worked. what i need to have is a formula that calculates a new cell (say, "i") so that IF h is greater than or equal to a value of 8.0 (hours per day), then it automatically calculates the amount of hours over 8.0, keeping the regular hours worked 8.0 in cell "h", and calculating the overtime hours as anything over 8.0 into new cell, "i". hope that makes sense? can anyone help me? thank you!!! |
#2
|
|||
|
|||
In h1: =MIN(C1+F1,--"08:00:00")
In i1: =C1+F1-H1 format the cells as time -- HTH RP (remove nothere from the email address if mailing direct) "jv749297" wrote in message news i am trying to create a timesheet that calculates cells automatically when data is entered. I am entering time "in" and "out" two times (first half of day total, then second half of day total, after meal break) and then i have a formula which calculates those totals. In algebraic terms, say: a+b=c, then for the second half of the day: d+e=f. then c+f=h, to give total hours worked. what i need to have is a formula that calculates a new cell (say, "i") so that IF h is greater than or equal to a value of 8.0 (hours per day), then it automatically calculates the amount of hours over 8.0, keeping the regular hours worked 8.0 in cell "h", and calculating the overtime hours as anything over 8.0 into new cell, "i". hope that makes sense? can anyone help me? thank you!!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Subtracting paid hours from unpaid hours | ejerry7 | Worksheet Functions | 5 | November 29th, 2004 05:16 AM |
too complex for me! | RandyH | Setting Up & Running Reports | 8 | July 2nd, 2004 05:37 PM |
SumIf Formula help to figure CA Overtime Laws | maxwellkitty | Worksheet Functions | 1 | March 12th, 2004 03:59 PM |
NEED HELP WITH FORMULA FOR CALC HOURS AND OVERTIME | PhAnToMiCe71898 | Worksheet Functions | 1 | September 26th, 2003 04:47 AM |