round to nearest 30-minute interval

  • Thread starter Thread starter Jeff Norville
  • Start date Start date
J

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
 
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
Click to expand...

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
 
Back
Top