fireprograms_tech
asked on
Need to calculate the number of events that occurred with in time frames during the day
We have a database field that is a date/time field named AlarmDate. I need a formula to look at the time in this field and determine if it is between 6am and 5:59:59pm or if it is between 6pm and 5:59:59am so that I can count the number of events that occurred in each time frame
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much this was a great solution
If Hour({table.alarmdate})>=6
If Hour({table.alarmdate})<6 or Hour({table.alarmdate})>=1
Save each field with a meaningful name.
Then you just use Insert>Summary (twice) to Sum each of these fields.