Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Question
My time data looks like this (formated as number)
93245 124316 135946 I would like a formula that will round the time to the nearest "5" minutes. Results like this: 930 1245 1400 Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting question with Round | Excel Worksheet Functions | |||
Round Up and Round Down Time | Excel Worksheet Functions | |||
Round-Up question | Excel Discussion (Misc queries) | |||
Round-Up question | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |