| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding time values up and down
Sorry if this has been asked before but i have time values in cells
formatted h.hh I need to round the values to the nearest hour for example a time of 13:15 needs to be rounded to 13 and a time of 08:45 would be rounded to 09 Hope this makes sense Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding Time values | Excel Discussion (Misc queries) | |||
| Rounding time | Excel Worksheet Functions | |||
| Time and rounding | New Users to Excel | |||
| Rounding Time? | Excel Worksheet Functions | |||
| Rounding Time? | Charts and Charting in Excel | |||
Threaded Mode
