Ok so this is the format that is coming up in the cell that I formatted to reflect [h]:mm
4/11/2004 914128:30
Is this what it's supposed to look like? I am still showing 10 as the answer.
Thank you again
Shannon
Ok so this is the format that is coming up in the cell that I formatted to reflect [h]:mm
4/11/2004 914128:30
Is this what it's supposed to look like? I am still showing 10 as the answer.
Thank you again
Shannon
Ok so here is what I am getting
A B
4/7/2004 8:00 4/7/2004 17:00 23
4/8/2004 16:00 4/8/2004 22:00 10
4/11/2004 8:00
The First column is the time in and the second is time out. The 23 and 10 that you see between the lines are the calculations of A - B. Such as A2-B1=23 which is great! But why is A3-B2=10? 4/11/2004 is 3 days from 4/8/2004. It should be more like A3-B2=58. What am I doing wrong?
Thank you for the help! :biggrin:
Shannon
Ok, here goes... I am at work trying to figure out how to get Excel to recognize the 24hrs in a day. What I have to do is, make a time card that would reflect that if a person has 34+ hours off their time would recycle back to 70. Reason? I have to keep track of this in Excel. To comply with Washington Law our drivers cannot work more than 70 hours without time off. But if they have 34+ hours off then the cycle starts all over again and they have a pool of 70hrs to work from. I hope this makes sense. So I need a formula or an idea of how to make this happen in Excel! Please Help!
Thank you!
Shannon :bouncing: