F
FJ Shepley & JM Pfohl
I need the following formula to round off to the nearest minute. Currently
it just drops the seconds off without rounding the minute off.
+b11-b10
where...
B10 is currently =TIME(HOUR(B10),MINUTE(B10)+$D$43/$D$40*$D$44/100,0)
B11 is currently =TIME(HOUR(B11),MINUTE(B11)+$D$43/$D$40*$D$44/100,0)
D43 is currently 189.52
D40 is currently 15.47
D44 is currently 100
I can't seem to find the proper cell format to show the minutes rounded off.
These cells are from a time sheet calculating how often a new batch can be
run.
I hope this is enough info.
Thanks,
Frank.
it just drops the seconds off without rounding the minute off.
+b11-b10
where...
B10 is currently =TIME(HOUR(B10),MINUTE(B10)+$D$43/$D$40*$D$44/100,0)
B11 is currently =TIME(HOUR(B11),MINUTE(B11)+$D$43/$D$40*$D$44/100,0)
D43 is currently 189.52
D40 is currently 15.47
D44 is currently 100
I can't seem to find the proper cell format to show the minutes rounded off.
These cells are from a time sheet calculating how often a new batch can be
run.
I hope this is enough info.
Thanks,
Frank.