Timesheets

[Angie]

Im really hoping someone can help me on this.

I have created a timesheet that records hours worked no problem. But with
also have flexi time in our job so I was hoping to take the total from 33.75
(avg hours worked in a week) then If it is a debit in hours worked it will
show in a cell or if there is a credit it will show in another. Can someone
please post me the formula.

Thanks

Angie

 

[Sean Timmons]

in the negative value cell, enter:

=IF(33.75-hours worked>=0,hours worked-33.75,"")

in the positive value cell, enter:

=IF(33.75-hours worked<0,hours worked-33.75,"")

 

[Angie]

Thank you very much You have saved me hours of work

Much appreciated

Angie

 

[Sean Timmons]

Wow, I should give you my paypal account!

Thank you for the feedback. Makes it worth it to provide answers!