Is there something like an "If, then" formula?
Yeah,
=MAX(total_hours,40)
but don't use the result of this in the overtime calculation <vbg
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"~working mom~" wrote in message
...
Thank you, that works for figuring the weekly overtime out. Do you know
how
to make the "total hours" cell stop at 40?
So that I have Regular hours 40 and then in the other cell it show the
number of OT hours? Right now it shows: regular hours 42.5 OT hours
2.5.
"Bob Phillips" wrote:
use a formula in the other cell of
=MAX(total_time-40,0)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"~working mom~" <~working wrote in
message
...
I am trying to set up a time card that I downloaded from the templates
page
on MS. I like the format of the one that I have, but this is what I
want
it
to do:
Currently it is set up to calculate time for the week as streight
time,
i.e.
56.4 hours for the week.
What I would like it to do is when the total number of hours reaches
40,
then anything over that goes into another cell for the number of
over-time
hours.
Is there a formula that anyone knows that I can use for this, or a
function?
|