Hello,

I am stuck! I need to calculate attendance by half hour increments. The scenario is that within a 24 hour period, folks can have a shift starting and ending at any time.

How would one count attendance for that 24 hour period by half hour increments?

Any help would be greatly appreciated.

Elizabeth

I'm not sure what exactly you're after, but this calculation:

Round(time1/1800,0) * (1800)

should give you a time field rounded to the nearest half-hour. (Internally, FM stores time as an integer, so 1800 seconds every half hour)

Jeff

Jeff,

Thanks. I have the time field part straight. My problem is that I need to be able to calculate how many people are in attendance at any given time. There is a maximum of say, 5 people, allowed at once. So, if someone was there 8-4, someone else 9-5, someone else 9-6, etc. I would need to be able to calculate when the cap of 5 people fluctuates to allow for a new person to come.

It's hard to put into words, so forgive me if I'm not being clear. Thanks for any help you might be able to give!

Elizabeth

Sounds like you need to use the Count function.

Let's assume you have a calculation named c.InAttendanceNow, which determines if a person is currently in attendance. It'll have some way of knowing that a person arrived but has not yet left.

Make another calculation field with Count(c.InAttendanceNow), this is the number of people currently in attendance.