formula or calculation for adding negative hour and positive hours
 

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)

formula or calculation for adding negative hour and positive hours
 

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)