Is there something like an "If, then" formula?

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?

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

The simplest way would be to add 2 columns, normal time and overtime. If
straight time is in F2, then in say G2 enter =IF(F2<=40,F2,IF(F2>40,40,""))
and in H2 enter =IF(F2="","",IF(F2<=40,0,F2-40))

"~working mom~" wrote:

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

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

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