software

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)

quot;~working mom~quot; lt;~working gt; wrote in message
...
gt; I am trying to set up a time card that I downloaded from the templates
page
gt; on MS. I like the format of the one that I have, but this is what I want
it
gt; to do:
gt;
gt; Currently it is set up to calculate time for the week as streight time,
i.e.
gt; 56.4 hours for the week.
gt;
gt; What I would like it to do is when the total number of hours reaches 40,
gt; then anything over that goes into another cell for the number of over-time
gt; hours.
gt;
gt; 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(F2lt;=40,F2,IF(F2gt;40,40,quot;quot;))
and in H2 enter =IF(F2=quot;quot;,quot;quot;,IF(F2lt;=40,0,F2-40))

quot;~working mom~quot; wrote:

gt; I am trying to set up a time card that I downloaded from the templates page
gt; on MS. I like the format of the one that I have, but this is what I want it
gt; to do:
gt;
gt; Currently it is set up to calculate time for the week as streight time, i.e.
gt; 56.4 hours for the week.
gt;
gt; What I would like it to do is when the total number of hours reaches 40,
gt; then anything over that goes into another cell for the number of over-time
gt; hours.
gt;
gt; 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 quot;total hoursquot; 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.

quot;Bob Phillipsquot; wrote:

gt; use a formula in the other cell of
gt;
gt; =MAX(total_time-40,0)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;~working mom~quot; lt;~working gt; wrote in message
gt; ...
gt; gt; I am trying to set up a time card that I downloaded from the templates
gt; page
gt; gt; on MS. I like the format of the one that I have, but this is what I want
gt; it
gt; gt; to do:
gt; gt;
gt; gt; Currently it is set up to calculate time for the week as streight time,
gt; i.e.
gt; gt; 56.4 hours for the week.
gt; gt;
gt; gt; What I would like it to do is when the total number of hours reaches 40,
gt; gt; then anything over that goes into another cell for the number of over-time
gt; gt; hours.
gt; gt;
gt; gt; Is there a formula that anyone knows that I can use for this, or a
gt; function?
gt;
gt;
gt;

Yeah,

=MAX(total_hours,40)

but don't use the result of this in the overtime calculation lt;vbggt;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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