I am trying to write a formula that will calculate the number of meals served based on arrival time and date into the local jail. Meal times are 0650, 1150, 1550 & 1930. I need the formula to be based on book in date and time through out date and time so that the correct number of meals are billed for. this could span a number of day or several months. I;m not sure if there is any way that this can be done but I would greatly appreciate any help that anyone can provide.
Bookmarks