Excel timesheet - netting sick, vacation, with extra time worked

[raeofsunshine]

Hi, I like many other do not pay OT until a person actually works 40 hours. So if a person works 10 hours on Monday (2 hours of OT) but takes 2 hours of sick time on Tuesday. I want my spreadsheet to Net the sick time on Tuesday against the two hours extra time worked on Monday. I think I am trying to make my timesheet too complicated but I always say that excel can do just about anything. As a side note, I want sick or vacation or any time not worked to be able to net against extra time worked. i hope that makes sense thanks so much!!!

 

[Jeffrey Lopez]

Can you post a sample of your timesheet? Would be easier if we could see how your sheet is set up before we start throwing out formulas. To answer your questions, it should be possible, and yes excel can do just about anything!

 

[raeofsunshine]

Thanks Jeffrey. I will have to figure out how to post my spreadsheet first!

 

[Jeffrey Lopez]

Even just a screenshot would be good... you can upload screen shots to sites like imgur, and you if you have dropbox you can put the file in your public folder and share the link that way.