Timesheets
 

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

Timesheets
 

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

Timesheets
 

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

Timesheets
 

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