Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding of Time | Excel Worksheet Functions | |||
Rounding Time Calculations | Excel Worksheet Functions | |||
rounding time question | Excel Worksheet Functions | |||
unmet challenge | Excel Worksheet Functions | |||
Rounding time in excel (2003) | Excel Discussion (Misc queries) |