round to nearest 30-minute interval

[Jeff Norville]

I have one measure of regularly-collected data (half hour interval)
and am comparing individual, randomly-timed measures against that
stream.

Thought I'd find a simple function - like ROUND() or similar - to find
the nearest date stamp. Occurs to me MOD() may be the way to go, but
I'm sure somebody's solved this one before. Got tips?

Thanks in advance,
Jeff

 

[Lars-Åke Aspelin]

I have one measure of regularly-collected data (half hour interval)
and am comparing individual, randomly-timed measures against that
stream.

Thought I'd find a simple function - like ROUND() or similar - to find
the nearest date stamp. Occurs to me MOD() may be the way to go, but
I'm sure somebody's solved this one before. Got tips?

Thanks in advance,
Jeff

Try this formula:

=MROUND(A1,1/48)

Don't forget to apply a proper format to the cell with this formula.

Hope this helps / Lars-Åke

 

[Mike H]

A non ATP method

=ROUND(A1*48,0)/48

Mike