How to calculate a half day

Half day calculation for Unpaid absence

Make sure there is just enough data to make it clear what is needed. September 08, 2009 09: Regards, JG. This site in other languages x. Again, it is important that I am able to aggregate these values further show a total of absences by day count for a given time period.

how to calculate a half day

I really just need a very simplified table of data, similar to this:. In the table, you'll also want to filter to exclude NULL values. Tech Sign In Page. The basic problem is to calculate for every day and every student ID the number of periods the student is absent or tardy.

Working hours for half-day holiday

You don't have JavaScript enabled. Please type your message and try again. The time now is 12: The tasks generally require table calcs, since you need to aggregate at different levels, first calculating the number of periods a student is absent on a particular day and then either 1 summing the result of all students for each day for the graph of 2 summing all days for a student for the table report.

how to calculate a half day

Note- it's calculating half day for week days. While these table calcs are not difficult, they are a bit tedious and most of the items in the table report will require a table calc, since the class period level of detail is required in the view but you need your fields to operate at a higher level of aggregation. The requirement is to configure sick leave. Page 1 of 2 1 2 Last Jump to page: If that isn't possible, I understand. Bookmarks Bookmarks Digg del.

how to calculate a half day

If I take calendar days then Saturday, Sunday are counted for reduction but 0.