John,

For times, including those that cross midnight try using:

=((C3-B3)+(B3C3))*24

or

=MOD(C3-B3,1)*24

with the cell formatted as General or Number

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"John L" wrote in
message ...

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