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

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" <[email protected]> wrote in message
news:[email protected]...
> 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!!!