Time formatting

J

Jay

Hello Does anyone know how to format grouping your data in
reports in half hour and 15 minute increments?
 
D

Duane Hookom

Since one day is the equivalent of "1" then one hour is 1/24 and a half hour
is 1/48. Therefore, you can set the sorting and grouping dialog to something
like:
=Int([DateTimeField] * 48)
or
=Int([DateTimeField] * 96)
 
Top