I don't see how 9.85 hours can ever be 9 hours and 3 quarters?

If you use start time 15:30 and end time 01:15, that gives a result of 9:45
or 9.75 using decimals, that is 3 quarters

you can round it to the nearest 0.25 and then use

=MOD(ROUND(A1*4,0)/4,1)/0.25

--

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


"Peter Wu" <Peter wrote in message
...
I would like to show the difference between start and end time in hours and
quarter in Excel 2003. Example:

Start time End time Result
15.30 1.15 9.85

I would like to see the result column showing 9 hours and 3 quarters,
instead of 9.85 hrs. Can anyone help. Im using Microsoft