Converting time to decimal then rounding
Maybe:
ROUNDUP((A1-A2)*24,1)
Micky
"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!!
|