Hello,
I am trying to round times in a way that is inconsistent with the default MROUND command
I need to round times to the half-hour, but based on a cut-off of :16, rather than the Excel default of :15 (i.e., MROUND). Exact half-hour and hour times should remain unchanged.
Examples:
1:15 rounds down to 1:00 and 1:16 rounds up to 1:30.
1:43 rounds down to 1:30 and 1:47 rounds up to 2:00.
1:30 = 1:30 and 2:00 = 2:00
Is there an easy way to do this? Thanks for the assistance!
Bookmarks