| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time rounding help
I am working on a time sheet that I need to tweak slightly, currently
I have a time in and time out log: In: 6:58 Out 17:36 I am trying to round these numbers to the nearest hour 6:58 to 7am, however 17:36 needs to round down to 17:00. The formula I am curently using is: =TIME(HOUR(B9),MROUND(MINUTE(B9),$M$1),0) The M references the rounding #. It is currently set at 60. Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| Excel Time Sheet - Rounding To Quarter Hours | Excel Worksheet Functions | |||
| Rounding Time? | Charts and Charting in Excel | |||
| rounding time question | Excel Worksheet Functions | |||
| Rounding time in excel (2003) | Excel Discussion (Misc queries) | |||
Threaded Mode
