MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time sheets

Posted by Lori on February 05, 2002 1:25 PM

I need to set up a spreadsheet that tracks remaining sick-time for employees. I have been playing with this for days and can't come up with anything! This sheet will track time taken and available time remaining for the entire year. If they take more time than they have, it needs to split it into days and then hours.

Ex: Employee has 24 sick hours available. If he takes a day, we will key in 8 hrs taken and then it whould show 16 remaining hours.

Another scenario is if he takes 32 hours, it should show 0 remaining, and 8 hours in a "NO Pay" column.

Lastly, if he took 36 hours, it should show 0 time remaining, and 1 day in a "NO PAY" column, and 4 hours in another "NO PAY" column. Any ideas?

Posted by Jack in th UK on February 05, 2002 3:34 PM

This seems like a project to me not a question tis message board is designed for, and you have asked about 6 questions all in one, its hard as i cant see what ou have and willing as i am ever that a hard nut to crack.

Im not posting this to be difficul i work all day and now at night and post as i can so i wont have the time to support yu as i would love.

Can i suggets you post small fast questions and then another even if 10 a day as you solve each part then people will be easirer to help and you get all the answers..

Sorry to sound only trying to advise you and hep you best i can.


Posted by Steve Hartman on February 06, 2002 6:48 AM

The board messed up and lost your reply to jack below and put my answer in the wrong place so I'll try again:

=INT(46) will give you the 5 days
=MOD(46,8) will give you the 6 hours

Posted by Rick Scott on February 07, 2002 8:15 AM

Lori, have you found a solution yet?