Thanks Mike h This solves the first past of question but not second for as
soon as i carry out the calculation C1*3.90 i get the answer 0.28 and should
be 6.825.

"Mike H" wrote:

Perhaps this in c1

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

Mike

"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?