Hi All,
I am developing a spreadsheet for my group to administer the vaccine. Each group will have a different start time, end time and duration of the appointment (this could be 5 min, 10 mins, 15 mins). How do you calculate the increments of time based on the start time, end time and duration with the formula stopping at the end time that is entered
I need the user to enter in the start time and the end time and the duration and have the formula calculate all of the intervals up to the end time entered. I figured out the formula to calculate the intervals, is there away to write it to stop calculating when it hits the end time. Current Formula is =B6+TIME(0,$E$2,0). The reason I need it to stop at the end time is I have to a count of the number of increment slots in a separate field.
Any help would be appreciated
I am developing a spreadsheet for my group to administer the vaccine. Each group will have a different start time, end time and duration of the appointment (this could be 5 min, 10 mins, 15 mins). How do you calculate the increments of time based on the start time, end time and duration with the formula stopping at the end time that is entered
I need the user to enter in the start time and the end time and the duration and have the formula calculate all of the intervals up to the end time entered. I figured out the formula to calculate the intervals, is there away to write it to stop calculating when it hits the end time. Current Formula is =B6+TIME(0,$E$2,0). The reason I need it to stop at the end time is I have to a count of the number of increment slots in a separate field.
Any help would be appreciated