Time in 30-minute increments

[caloy]

I have intraday data with Date/time values. I want to be able to aggregate
the time into 30-minute segments. What functions or expressions can I use?

 

[Michel Walsh]

You can group on a computed expression, like:


CDate( CDec(#00:30:00#) * INT(CDec(yourDateTimeValue) / CDec(#00:30:00#)) )




Hoping it may help,
Vanderghast, Access MVP

 

[John W. Vinson/MVP]

I have intraday data with Date/time values. I want to be able to aggregate
the time into 30-minute segments. What functions or expressions can I use?

Try

cdate(clng(CDbl([datefield])*48)/48)

 

[Allen Browne]

I have intraday data with Date/time values. I want to be able to aggregate
the time into 30-minute segments. What functions or expressions can I use?

Michael has given you are very versatile expression, and John has given you
a specific answer.

Here's another way to *round* to the nearest so-many number of seconds or
minutes:
http://allenbrowne.com/round.html#RoundTime