Hi all

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 by going to this web
site(http://www.alrm.org.au/images/stories//timesheet.xls)

I need to make sure that any amount over the 70 hours is displayed in
cell K24

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


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