a bit simpler

=ROUND((B1-A1)*96,0)/96

"jockj215" wrote:

Hi I have a small problem which should be easy to do but frustrating me just
a bit. I have some pool cars with different departments which need to be
charge for their use. I get weekly sheets in with start time and end time of
use. i.e. A1 08:45 B1 10:25 I need to calculate as follows C1 time car used
to nearest 15 minutes. D1 cost of use (C1*3.90). Should be easy but I think I
am making hard work of this and am sure there is a simple answer?