Wow, I should give you my paypal account! :-P

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

"Angie" wrote:

Thank you very much You have saved me hours of work

Much appreciated

Angie

"Sean Timmons" wrote:

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" wrote:

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