and Mike H where does 96 come from?

There are 96 quarter hours in a day

"jockj215" wrote:

Thanks both seem to be good ways round problem, Teethless mama I thought
mround would work will need to get IT to add to my computer at work can i ask
where does 93.6 come from? and Mike H where does 96 come from? Me a bit thick
with these things so appreciate the help. as the £3.90 is the hourly cost and
is due for review so may change soon.

"Teethless mama" wrote:

=MROUND(B1-A1,TIME(,15,))*93.6

Format cell as General


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