Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Time.
How can I round time UP to the nearest 5 min. I need to have the report in
numbers divisible by 5 and the time should always go up. 1:30, 1:35, 1:40, 1:45. For example, 1:41 round it to 1:45 1:43 round it to 1:45 1:46 round it to 1:50 1:48 round it to 1:50 1:40 is kept at 1:40 1:50 is kept at 1:50 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding time | Excel Worksheet Functions | |||
rounding time | Excel Worksheet Functions | |||
Time rounding help | Excel Discussion (Misc queries) | |||
Rounding off TIME | Excel Discussion (Misc queries) | |||
Rounding of Time | Excel Worksheet Functions |