View Single Post
  #1   Report Post  
FJ Shepley & JM Pfohl
 
Posts: n/a
Default Rounding off TIME

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.