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

 

[David Biddulph]

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

 

[Daryl S]

JB -

Skip the MOD for time values:

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