Here is where i am at this time.
I got it to do the .5 or.75 time thing.
But what now is my problem is figuring out employee time.
In cell ( A ) is start time. Amber is on row 3
In cell ( b ) is end time.
In cell (c ) is name.
In ( d ) is Hours.
5:00 PM - 11:00 PM - Amber- 6.0 This is ok
This is what I have...=(b3-a3)*24
Using the above formula.
If an employee starts at 5:00 pm and works till 11:00 pm it works
fine.
If an employee starts at 5:00 pm and works till 12:00 am it gives
-17.0
If an employee starts at 5:00 pm and works till 1:00 am it gives -16.0
So what is my solution?
John L
--
John L
------------------------------------------------------------------------
John L's Profile:
http://www.excelforum.com/member.php...o&userid=34774
View this thread:
http://www.excelforum.com/showthread...hreadid=571777