Timesheets

A

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
 
S

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,"")
 
S

Sean Timmons

Wow, I should give you my paypal account! :p

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top