software

I am trying to make a time sheet for everyone to be able to use in the
office. I want it to where when the total in Regular working hours reaches
37.5 it will put the excess working hours into another cell called of course
Overtime. My dilema is not only this it is also that there are 2 colums of
overtime. There is overtime for 37.5 hrs to 40 and then there is a column for
40 hrs. Im so puzzled and confused I dont know if this is even going to be
possible or how to even go about setting it up in a way that it WILL work. If
anyone can please help me that would be so wonderful! If you want to see the
document I have put together so far I can email it to you.

Thanks!


Using A1 as the cell containing the total hours worked:

For the first part of the OT use:
=IF(A1gt;37.5,A1-37.5,quot;quot;)

For the second part of the OT use:
=IF(A1gt;40,A1-40,quot;quot;)--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=527581=MIN(MAX(num_hours-37.5,0),2.5)

for hours between 37.5 and 40

=MAX(num_hours-40,0)

for hours over 40

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;GettingaHeadachequot; gt; wrote in
message ...
gt; I am trying to make a time sheet for everyone to be able to use in the
gt; office. I want it to where when the total in Regular working hours reaches
gt; 37.5 it will put the excess working hours into another cell called of
course
gt; Overtime. My dilema is not only this it is also that there are 2 colums of
gt; overtime. There is overtime for 37.5 hrs to 40 and then there is a column
for
gt; 40 hrs. Im so puzzled and confused I dont know if this is even going to
be
gt; possible or how to even go about setting it up in a way that it WILL work.
If
gt; anyone can please help me that would be so wonderful! If you want to see
the
gt; document I have put together so far I can email it to you.
gt;
gt; Thanks!
I'm not quite sure what to do here, I am new to the advanced formulas in
excel. I dont want the employees to have to enter anything but their time. So
in the formula =MIN(MAX(num_hours-37.5,0),2.5) what do I put in quot;num_hoursquot;?

Ok lets say that their regular hours total 52.50 which is obviously 15 hrs
of overtime but there is going to be 37.5-40 hrs of overtime which is only
2.5hrs and then there is 40 hrs which is 12.5hrs how do I make it to where
the 2.5hrs of overtime will hit the cell quot;a1quot; for example and the 12.5hrs
will hit cell quot;a2quot; automatically? I am not sure if I am explaining this clear
enough but I dont know how else to say it. Please Help!!!

quot;Bob Phillipsquot; wrote:

gt; =MIN(MAX(num_hours-37.5,0),2.5)
gt;
gt; for hours between 37.5 and 40
gt;
gt; =MAX(num_hours-40,0)
gt;
gt; for hours over 40
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;GettingaHeadachequot; gt; wrote in
gt; message ...
gt; gt; I am trying to make a time sheet for everyone to be able to use in the
gt; gt; office. I want it to where when the total in Regular working hours reaches
gt; gt; 37.5 it will put the excess working hours into another cell called of
gt; course
gt; gt; Overtime. My dilema is not only this it is also that there are 2 colums of
gt; gt; overtime. There is overtime for 37.5 hrs to 40 and then there is a column
gt; for
gt; gt; 40 hrs. Im so puzzled and confused I dont know if this is even going to
gt; be
gt; gt; possible or how to even go about setting it up in a way that it WILL work.
gt; If
gt; gt; anyone can please help me that would be so wonderful! If you want to see
gt; the
gt; gt; document I have put together so far I can email it to you.
gt; gt;
gt; gt; Thanks!
gt;
gt;
gt;

num_hours refers to the number of hours worked, 52.5 in your example.

Assuming that the hours are in a cell, let's say A1, you just add those
formulae to A2 and A3

=MIN(MAX(A1-37.5,0),2.5)

=MAX(A1-40,0)

When your use puts their time in A1, the others autonmatically calculate

HTH

MigraineRelieverquot;GettingaHeadachequot; gt; wrote in
message ...
gt; I'm not quite sure what to do here, I am new to the advanced formulas in
gt; excel. I dont want the employees to have to enter anything but their time.
So
gt; in the formula =MIN(MAX(num_hours-37.5,0),2.5) what do I put in
quot;num_hoursquot;?
gt;
gt; Ok lets say that their regular hours total 52.50 which is obviously 15 hrs
gt; of overtime but there is going to be 37.5-40 hrs of overtime which is only
gt; 2.5hrs and then there is 40 hrs which is 12.5hrs how do I make it to
where
gt; the 2.5hrs of overtime will hit the cell quot;a1quot; for example and the 12.5hrs
gt; will hit cell quot;a2quot; automatically? I am not sure if I am explaining this
clear
gt; enough but I dont know how else to say it. Please Help!!!
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =MIN(MAX(num_hours-37.5,0),2.5)
gt; gt;
gt; gt; for hours between 37.5 and 40
gt; gt;
gt; gt; =MAX(num_hours-40,0)
gt; gt;
gt; gt; for hours over 40
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;GettingaHeadachequot; gt; wrote in
gt; gt; message ...
gt; gt; gt; I am trying to make a time sheet for everyone to be able to use in the
gt; gt; gt; office. I want it to where when the total in Regular working hours
reaches
gt; gt; gt; 37.5 it will put the excess working hours into another cell called of
gt; gt; course
gt; gt; gt; Overtime. My dilema is not only this it is also that there are 2
colums of
gt; gt; gt; overtime. There is overtime for 37.5 hrs to 40 and then there is a
column
gt; gt; for
gt; gt; gt; 40 hrs. Im so puzzled and confused I dont know if this is even going
to
gt; gt; be
gt; gt; gt; possible or how to even go about setting it up in a way that it WILL
work.
gt; gt; If
gt; gt; gt; anyone can please help me that would be so wonderful! If you want to
see
gt; gt; the
gt; gt; gt; document I have put together so far I can email it to you.
gt; gt; gt;
gt; gt; gt; Thanks!
gt; gt;
gt; gt;
gt; gt;
Ahh! I got it!!! Now my new task is how to have it calculate their leave and
vaction time into their hours.. Any suggestions?! You are a ton of help!
Thanks!quot;Bob Phillipsquot; wrote:

gt; num_hours refers to the number of hours worked, 52.5 in your example.
gt;
gt; Assuming that the hours are in a cell, let's say A1, you just add those
gt; formulae to A2 and A3
gt;
gt; =MIN(MAX(A1-37.5,0),2.5)
gt;
gt; =MAX(A1-40,0)
gt;
gt; When your use puts their time in A1, the others autonmatically calculate
gt;
gt; HTH
gt;
gt; MigraineReliever
gt;
gt;
gt; quot;GettingaHeadachequot; gt; wrote in
gt; message ...
gt; gt; I'm not quite sure what to do here, I am new to the advanced formulas in
gt; gt; excel. I dont want the employees to have to enter anything but their time.
gt; So
gt; gt; in the formula =MIN(MAX(num_hours-37.5,0),2.5) what do I put in
gt; quot;num_hoursquot;?
gt; gt;
gt; gt; Ok lets say that their regular hours total 52.50 which is obviously 15 hrs
gt; gt; of overtime but there is going to be 37.5-40 hrs of overtime which is only
gt; gt; 2.5hrs and then there is 40 hrs which is 12.5hrs how do I make it to
gt; where
gt; gt; the 2.5hrs of overtime will hit the cell quot;a1quot; for example and the 12.5hrs
gt; gt; will hit cell quot;a2quot; automatically? I am not sure if I am explaining this
gt; clear
gt; gt; enough but I dont know how else to say it. Please Help!!!
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; =MIN(MAX(num_hours-37.5,0),2.5)
gt; gt; gt;
gt; gt; gt; for hours between 37.5 and 40
gt; gt; gt;
gt; gt; gt; =MAX(num_hours-40,0)
gt; gt; gt;
gt; gt; gt; for hours over 40
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;GettingaHeadachequot; gt; wrote in
gt; gt; gt; message ...
gt; gt; gt; gt; I am trying to make a time sheet for everyone to be able to use in the
gt; gt; gt; gt; office. I want it to where when the total in Regular working hours
gt; reaches
gt; gt; gt; gt; 37.5 it will put the excess working hours into another cell called of
gt; gt; gt; course
gt; gt; gt; gt; Overtime. My dilema is not only this it is also that there are 2
gt; colums of
gt; gt; gt; gt; overtime. There is overtime for 37.5 hrs to 40 and then there is a
gt; column
gt; gt; gt; for
gt; gt; gt; gt; 40 hrs. Im so puzzled and confused I dont know if this is even going
gt; to
gt; gt; gt; be
gt; gt; gt; gt; possible or how to even go about setting it up in a way that it WILL
gt; work.
gt; gt; gt; If
gt; gt; gt; gt; anyone can please help me that would be so wonderful! If you want to
gt; see
gt; gt; gt; the
gt; gt; gt; gt; document I have put together so far I can email it to you.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

I would need a bit more detail to know how the leave is shown on the s/s.
What is the difference between leave and vacation time?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;GettingaHeadachequot; gt; wrote in
message ...
gt; Ahh! I got it!!! Now my new task is how to have it calculate their leave
and
gt; vaction time into their hours.. Any suggestions?! You are a ton of help!
gt; Thanks!
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; num_hours refers to the number of hours worked, 52.5 in your example.
gt; gt;
gt; gt; Assuming that the hours are in a cell, let's say A1, you just add those
gt; gt; formulae to A2 and A3
gt; gt;
gt; gt; =MIN(MAX(A1-37.5,0),2.5)
gt; gt;
gt; gt; =MAX(A1-40,0)
gt; gt;
gt; gt; When your use puts their time in A1, the others autonmatically calculate
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; MigraineReliever
gt; gt;
gt; gt;
gt; gt; quot;GettingaHeadachequot; gt; wrote in
gt; gt; message ...
gt; gt; gt; I'm not quite sure what to do here, I am new to the advanced formulas
in
gt; gt; gt; excel. I dont want the employees to have to enter anything but their
time.
gt; gt; So
gt; gt; gt; in the formula =MIN(MAX(num_hours-37.5,0),2.5) what do I put in
gt; gt; quot;num_hoursquot;?
gt; gt; gt;
gt; gt; gt; Ok lets say that their regular hours total 52.50 which is obviously 15
hrs
gt; gt; gt; of overtime but there is going to be 37.5-40 hrs of overtime which is
only
gt; gt; gt; 2.5hrs and then there is 40 hrs which is 12.5hrs how do I make it to
gt; gt; where
gt; gt; gt; the 2.5hrs of overtime will hit the cell quot;a1quot; for example and the
12.5hrs
gt; gt; gt; will hit cell quot;a2quot; automatically? I am not sure if I am explaining
this
gt; gt; clear
gt; gt; gt; enough but I dont know how else to say it. Please Help!!!
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; =MIN(MAX(num_hours-37.5,0),2.5)
gt; gt; gt; gt;
gt; gt; gt; gt; for hours between 37.5 and 40
gt; gt; gt; gt;
gt; gt; gt; gt; =MAX(num_hours-40,0)
gt; gt; gt; gt;
gt; gt; gt; gt; for hours over 40
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;GettingaHeadachequot; gt;
wrote in
gt; gt; gt; gt; message ...
gt; gt; gt; gt; gt; I am trying to make a time sheet for everyone to be able to use in
the
gt; gt; gt; gt; gt; office. I want it to where when the total in Regular working hours
gt; gt; reaches
gt; gt; gt; gt; gt; 37.5 it will put the excess working hours into another cell called
of
gt; gt; gt; gt; course
gt; gt; gt; gt; gt; Overtime. My dilema is not only this it is also that there are 2
gt; gt; colums of
gt; gt; gt; gt; gt; overtime. There is overtime for 37.5 hrs to 40 and then there is a
gt; gt; column
gt; gt; gt; gt; for
gt; gt; gt; gt; gt; 40 hrs. Im so puzzled and confused I dont know if this is even
going
gt; gt; to
gt; gt; gt; gt; be
gt; gt; gt; gt; gt; possible or how to even go about setting it up in a way that it
WILL
gt; gt; work.
gt; gt; gt; gt; If
gt; gt; gt; gt; gt; anyone can please help me that would be so wonderful! If you want
to
gt; gt; see
gt; gt; gt; gt; the
gt; gt; gt; gt; gt; document I have put together so far I can email it to you.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks!
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
Leave is when you are sick, have a doctors appointment, sick relative etc.
Vacation is when you go on vacation or take a day off to do personal business.
Right now I dont have a format for the leave or vacation time my boss just
informed me she wants me to work it in there somehow. The setup I have atm is
regular hrs, leave hrs, vacation hrs, worked hrs, OT 37.5-40, OT 40 and
total hrs. What I eventually want is for worked hours to take out lunch hour,
vacation and leave time. The total hours would include the lunch hour,
vacation, and leave time so that way they know what they worked for that
whole day. Am i doing double duty on this? I dont want to confuse the payroll
with 2 totals plus OT totals let alone confuse the employees... If you want
to see the spreadsheet I can email it to you or you can contact me @
. Thanks!

quot;Bob Phillipsquot; wrote:

gt; I would need a bit more detail to know how the leave is shown on the s/s.
gt; What is the difference between leave and vacation time?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;GettingaHeadachequot; gt; wrote in
gt; message ...
gt; gt; Ahh! I got it!!! Now my new task is how to have it calculate their leave
gt; and
gt; gt; vaction time into their hours.. Any suggestions?! You are a ton of help!
gt; gt; Thanks!
gt; gt;
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; num_hours refers to the number of hours worked, 52.5 in your example.
gt; gt; gt;
gt; gt; gt; Assuming that the hours are in a cell, let's say A1, you just add those
gt; gt; gt; formulae to A2 and A3
gt; gt; gt;
gt; gt; gt; =MIN(MAX(A1-37.5,0),2.5)
gt; gt; gt;
gt; gt; gt; =MAX(A1-40,0)
gt; gt; gt;
gt; gt; gt; When your use puts their time in A1, the others autonmatically calculate
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; MigraineReliever
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;GettingaHeadachequot; gt; wrote in
gt; gt; gt; message ...
gt; gt; gt; gt; I'm not quite sure what to do here, I am new to the advanced formulas
gt; in
gt; gt; gt; gt; excel. I dont want the employees to have to enter anything but their
gt; time.
gt; gt; gt; So
gt; gt; gt; gt; in the formula =MIN(MAX(num_hours-37.5,0),2.5) what do I put in
gt; gt; gt; quot;num_hoursquot;?
gt; gt; gt; gt;
gt; gt; gt; gt; Ok lets say that their regular hours total 52.50 which is obviously 15
gt; hrs
gt; gt; gt; gt; of overtime but there is going to be 37.5-40 hrs of overtime which is
gt; only
gt; gt; gt; gt; 2.5hrs and then there is 40 hrs which is 12.5hrs how do I make it to
gt; gt; gt; where
gt; gt; gt; gt; the 2.5hrs of overtime will hit the cell quot;a1quot; for example and the
gt; 12.5hrs
gt; gt; gt; gt; will hit cell quot;a2quot; automatically? I am not sure if I am explaining
gt; this
gt; gt; gt; clear
gt; gt; gt; gt; enough but I dont know how else to say it. Please Help!!!
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; =MIN(MAX(num_hours-37.5,0),2.5)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; for hours between 37.5 and 40
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =MAX(num_hours-40,0)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; for hours over 40
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;GettingaHeadachequot; gt;
gt; wrote in
gt; gt; gt; gt; gt; message ...
gt; gt; gt; gt; gt; gt; I am trying to make a time sheet for everyone to be able to use in
gt; the
gt; gt; gt; gt; gt; gt; office. I want it to where when the total in Regular working hours
gt; gt; gt; reaches
gt; gt; gt; gt; gt; gt; 37.5 it will put the excess working hours into another cell called
gt; of
gt; gt; gt; gt; gt; course
gt; gt; gt; gt; gt; gt; Overtime. My dilema is not only this it is also that there are 2
gt; gt; gt; colums of
gt; gt; gt; gt; gt; gt; overtime. There is overtime for 37.5 hrs to 40 and then there is a
gt; gt; gt; column
gt; gt; gt; gt; gt; for
gt; gt; gt; gt; gt; gt; 40 hrs. Im so puzzled and confused I dont know if this is even
gt; going
gt; gt; gt; to
gt; gt; gt; gt; gt; be
gt; gt; gt; gt; gt; gt; possible or how to even go about setting it up in a way that it
gt; WILL
gt; gt; gt; work.
gt; gt; gt; gt; gt; If
gt; gt; gt; gt; gt; gt; anyone can please help me that would be so wonderful! If you want
gt; to
gt; gt; gt; see
gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; document I have put together so far I can email it to you.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thanks!
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Well there is nothing difficult about what you want, but until you show the
layout there is not much more to say, as it would just be guessing?

Mail me the spreadsheet

bob (dot) phillips (at) tiscali (dot) co (dot) uk

do the obvious with the bits in brackets

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;GettingaHeadachequot; gt; wrote in
message ...
gt; Leave is when you are sick, have a doctors appointment, sick relative etc.
gt; Vacation is when you go on vacation or take a day off to do personal
business.
gt; Right now I dont have a format for the leave or vacation time my boss just
gt; informed me she wants me to work it in there somehow. The setup I have atm
is
gt; regular hrs, leave hrs, vacation hrs, worked hrs, OT 37.5-40, OT 40 and
gt; total hrs. What I eventually want is for worked hours to take out lunch
hour,
gt; vacation and leave time. The total hours would include the lunch hour,
gt; vacation, and leave time so that way they know what they worked for that
gt; whole day. Am i doing double duty on this? I dont want to confuse the
payroll
gt; with 2 totals plus OT totals let alone confuse the employees... If you
want
gt; to see the spreadsheet I can email it to you or you can contact me @
gt; . Thanks!
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; I would need a bit more detail to know how the leave is shown on the
s/s.
gt; gt; What is the difference between leave and vacation time?
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;GettingaHeadachequot; gt; wrote in
gt; gt; message ...
gt; gt; gt; Ahh! I got it!!! Now my new task is how to have it calculate their
leave
gt; gt; and
gt; gt; gt; vaction time into their hours.. Any suggestions?! You are a ton of
help!
gt; gt; gt; Thanks!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; num_hours refers to the number of hours worked, 52.5 in your
example.
gt; gt; gt; gt;
gt; gt; gt; gt; Assuming that the hours are in a cell, let's say A1, you just add
those
gt; gt; gt; gt; formulae to A2 and A3
gt; gt; gt; gt;
gt; gt; gt; gt; =MIN(MAX(A1-37.5,0),2.5)
gt; gt; gt; gt;
gt; gt; gt; gt; =MAX(A1-40,0)
gt; gt; gt; gt;
gt; gt; gt; gt; When your use puts their time in A1, the others autonmatically
calculate
gt; gt; gt; gt;
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; MigraineReliever
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;GettingaHeadachequot; gt;
wrote in
gt; gt; gt; gt; message ...
gt; gt; gt; gt; gt; I'm not quite sure what to do here, I am new to the advanced
formulas
gt; gt; in
gt; gt; gt; gt; gt; excel. I dont want the employees to have to enter anything but
their
gt; gt; time.
gt; gt; gt; gt; So
gt; gt; gt; gt; gt; in the formula =MIN(MAX(num_hours-37.5,0),2.5) what do I put in
gt; gt; gt; gt; quot;num_hoursquot;?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Ok lets say that their regular hours total 52.50 which is
obviously 15
gt; gt; hrs
gt; gt; gt; gt; gt; of overtime but there is going to be 37.5-40 hrs of overtime which
is
gt; gt; only
gt; gt; gt; gt; gt; 2.5hrs and then there is 40 hrs which is 12.5hrs how do I make it
to
gt; gt; gt; gt; where
gt; gt; gt; gt; gt; the 2.5hrs of overtime will hit the cell quot;a1quot; for example and the
gt; gt; 12.5hrs
gt; gt; gt; gt; gt; will hit cell quot;a2quot; automatically? I am not sure if I am explaining
gt; gt; this
gt; gt; gt; gt; clear
gt; gt; gt; gt; gt; enough but I dont know how else to say it. Please Help!!!
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; =MIN(MAX(num_hours-37.5,0),2.5)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; for hours between 37.5 and 40
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; =MAX(num_hours-40,0)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; for hours over 40
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;GettingaHeadachequot; gt;
gt; gt; wrote in
gt; gt; gt; gt; gt; gt; message
...
gt; gt; gt; gt; gt; gt; gt; I am trying to make a time sheet for everyone to be able to
use in
gt; gt; the
gt; gt; gt; gt; gt; gt; gt; office. I want it to where when the total in Regular working
hours
gt; gt; gt; gt; reaches
gt; gt; gt; gt; gt; gt; gt; 37.5 it will put the excess working hours into another cell
called
gt; gt; of
gt; gt; gt; gt; gt; gt; course
gt; gt; gt; gt; gt; gt; gt; Overtime. My dilema is not only this it is also that there are
2
gt; gt; gt; gt; colums of
gt; gt; gt; gt; gt; gt; gt; overtime. There is overtime for 37.5 hrs to 40 and then there
is a
gt; gt; gt; gt; column
gt; gt; gt; gt; gt; gt; for
gt; gt; gt; gt; gt; gt; gt; 40 hrs. Im so puzzled and confused I dont know if this is
even
gt; gt; going
gt; gt; gt; gt; to
gt; gt; gt; gt; gt; gt; be
gt; gt; gt; gt; gt; gt; gt; possible or how to even go about setting it up in a way that
it
gt; gt; WILL
gt; gt; gt; gt; work.
gt; gt; gt; gt; gt; gt; If
gt; gt; gt; gt; gt; gt; gt; anyone can please help me that would be so wonderful! If you
want
gt; gt; to
gt; gt; gt; gt; see
gt; gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; document I have put together so far I can email it to you.
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Thanks!
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;