J Jay May 18, 2004 #1 Hello Does anyone know how to format grouping your data in reports in half hour and 15 minute increments?
Hello Does anyone know how to format grouping your data in reports in half hour and 15 minute increments?
D Duane Hookom May 18, 2004 #2 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)
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)
