im new to excel having just finished a course,
Now the boss thinks that i am an expert on excel,
And im far from it.

i have developed a timesheet that adds up the total hours worked and
lunch times etc but im having trouble with the TOIL side of things. you
can see a copy of the timesheet on the attached word doc. there is a
screen capture of the current formulas,

I need to make sure that any amount over the 70 hours is displayed in
cell K24 regardless of whats in I10:k23 so the sum fuction in k24 can
be removed if needs be.

also i need to display Total TOIL Carried over from the last timesheet
and have that added to any new time accumulated in the new F/N any
ideas or suggestions would be appreciated

Thanks,
Jesse


+-------------------------------------------------------------------+
|Filename: screencap.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3644 |
+-------------------------------------------------------------------+

--
Jesse_Norris
------------------------------------------------------------------------
Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546
View this thread: http://www.excelforum.com/showthread...hreadid=390465

Jesse,

Looks like you could use an "IF Then" Formula. You may know this but
just in case... An IF Then Formula will return one condition if
certain cells meet, or are true, to a set caritia or another result if
those same cells do not meet that caritia, or are false.

The formula below will do the following actions.

If the sum of K10 through K23 is greater than 70...it will Sum up that
range and then subtract 70. This will give you the amount over 70.
However if the range K10 through K23 is less than 70 a ZERO value will
be shown.

=IF(SUM(K10:K23)70,SUM(K10:K23)-70,0)

If you like you can also choose to hide ZERO values. This way if a cell
equals ZERO then it appears blank. Only when it is greater than ZERO
will it show a value.
To do this select [TOOLS][OPTIONS][VIEW TAB] Check Hide zero Values.


Hope this will work for you


--
JasonCrimmel
------------------------------------------------------------------------
JasonCrimmel's Profile: http://www.excelforum.com/member.php...o&userid=25638
View this thread: http://www.excelforum.com/showthread...hreadid=390465

Thanks for the help but it did not work
it all ways displays a 0 value.

Regards,
Jesse


--
Jesse_Norris
------------------------------------------------------------------------
Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546
View this thread: http://www.excelforum.com/showthread...hreadid=390465

Jesse_Norris Wrote:
im new to excel having just finished a course,
Now the boss thinks that i am an expert on excel,
And im far from it.

i have developed a timesheet that adds up the total hours worked and
lunch times etc but im having trouble with the TOIL side of things. you
can see a copy of the timesheet on the attached word doc. there is a
screen capture of the current formulas,

I need to make sure that any amount over the 70 hours is displayed in
cell K24 regardless of whats in I10:k23 so the sum fuction in k24 can
be removed if needs be.

also i need to display Total TOIL Carried over from the last timesheet
and have that added to any new time accumulated in the new F/N any
ideas or suggestions would be appreciated

Thanks,
Jesse


Is there any requirement that you insert the lunch hours used? Can you
just use the hours worked for your time sheet for each pay period? I
have two time sheets. I use one to calculate my hours and pay, the
other I use to fill out, print, and submit to mgmt. The 2nd one auto
calculates all time worked during the entire two week pay period.


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=390465

the current spreadsheet calculates the hole day less lunchbreak and
gives you total time taken for lunch and total time for the day in the
total at the bottom of the page gives the total for the F/N but the max
hours for the F/N is 70 Hours any thing over that is TOIL but management
want the times spelled out in a separate column to the rest with start
and finish times.

please if you need any more info please email me or reply to this post
my email is
Regards,
Jesse


--
Jesse_Norris
------------------------------------------------------------------------
Jesse_Norris's Profile: http://www.excelforum.com/member.php...o&userid=25546
View this thread: http://www.excelforum.com/showthread...hreadid=390465