Obviously a question of small rounding errors.
=MOD(T11*24*60-R11*24*60,24*60)/60 seems to work.
If it doesn't always work, you might need to round each component to whole
minutes by
=MOD(ROUND(T11*24*60,0)-ROUND(R11*24*60,0),24*60)/60
--
David Biddulph

JB Bates wrote:
Hi

I have a formula

=MOD(T11-R11,1)*24

Where T11 is 22:43 and R11 is 22:34

The difference of these time values is 9 minutes or .15. Currently I
am getting the result of .1 because it is not rounding up. The
result I need is .2 -- so that Excel will round .01 to .04 down and
.05 to .09 up.

How should I adjust my formula? Thanks!!