hi can any one help im trying to create a work sheet that will calculate my
weekly work hours (37 per week m8,t8,w8,t8,f5) which ive done to some success
but
1. if i have a day off then that days equivelant in hours need to be booked
to my working time account ( i owe the company)
2 if i work over 2 hours then 2 hrs need to be taken of my working time
account
3 at the end of the week a formula is needed to calculate how many hrs i owe
the company, how many hour the company owes me and the difference and then
the accumulate balance

ie if i start with a balance of 10 hrs (that the company owes me)
the following week i work 10 hrs extra mon-thurs i then have the friday off
(-5 hrs)the tot hour should = 15 hrs(company owes me) (10+10-5)
or
if i start with a balance of 10 hrs (company owes me)
the following week i work 0 hrs extra mon, tues, wed i then have the thurs
-friday off (-13 hrs)the tot hour should = -3 hrs(i owe company ) ( 10+0-13)

hope this explains clearly enough to resolve

( if you need the work sheet as the example then let me know)

What you want is not difficult, depending on the layout of your sheet!

I suggest you mail me your sheet, and I'll give it a go!

--
HTH

Kassie

Replace xxx with hotmail


"mort" wrote:

hi can any one help im trying to create a work sheet that will calculate my
weekly work hours (37 per week m8,t8,w8,t8,f5) which ive done to some success
but
1. if i have a day off then that days equivelant in hours need to be booked
to my working time account ( i owe the company)
2 if i work over 2 hours then 2 hrs need to be taken of my working time
account
3 at the end of the week a formula is needed to calculate how many hrs i owe
the company, how many hour the company owes me and the difference and then
the accumulate balance

ie if i start with a balance of 10 hrs (that the company owes me)
the following week i work 10 hrs extra mon-thurs i then have the friday off
(-5 hrs)the tot hour should = 15 hrs(company owes me) (10+10-5)
or
if i start with a balance of 10 hrs (company owes me)
the following week i work 0 hrs extra mon, tues, wed i then have the thurs
-friday off (-13 hrs)the tot hour should = -3 hrs(i owe company ) ( 10+0-13)

hope this explains clearly enough to resolve

( if you need the work sheet as the example then let me know)