Is there any reason you cannot use 05:30 to 11:15?

That will give you 05:45



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"North for Short"
<North.for.Short.2a1t4z_1151390703.3756@excelfor um-nospam.com wrote in
message news:North.for.Short.2a1t4z_1151390703.3756@excelf orum-nospam.com...

Yes, It isn't the actual format that I need it is the formula for the
result is what I need. for example

A Jones starts his shift at 05:00 in the morning and finishes at 11:00
( that is a straight forward 6.00 hours but if you write
A jones 05.30 to 11.15 you get 5.85. What I want to be able to do is
actually calculate the time which should read *5.45*


--
North for Short
------------------------------------------------------------------------
North for Short's Profile:
http://www.excelforum.com/member.php...o&userid=22695
View this thread: http://www.excelforum.com/showthread...hreadid=555198