Converting time to decimal then rounding

[JB Bates]

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!!

 

[מיכ×ל (מיקי) ×בידן]

Maybe:
ROUNDUP((A1-A2)*24,1)
Micky

 

[Daryl S]

JB -

Skip the MOD for time values:

=ROUND((T11-R11)*24,1)