Time Sheet for my org Im still having trouble

[Jesse_Norris]

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 an
lunch times etc but im having trouble with the TOIL side of things. yo
can see a copy of the timesheet on the attached word doc. there is
screen capture of the current formulas,

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

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

Thanks,
Jess

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

 

[JasonCrimmel]

Jesse,

Looks like you could use an "IF Then" Formula. You may know this bu
just in case... An IF Then Formula will return one condition i
certain cells meet, or are true, to a set caritia or another result i
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 tha
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 wil
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 cel
equals ZERO then it appears blank. Only when it is greater than ZER
will it show a value.
To do this select [TOOLS][OPTIONS][VIEW TAB] Check Hide zero Values.


Hope this will work for yo

 

[Jesse_Norris]

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

Regards,
Jess

 

[Ltat42a]

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.

 

[Jesse_Norris]

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 (e-mail address removed)
Regards,
Jesse