Calculate time intervals based on start and end time

[FireBott]

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

 

[mrshl9898]

10 in excel is 10 days so divide by 24 to get hrs and by 60 to get mins.

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 365

+Fluff 1.xlsm
	A	B	C	D	E
1
2		09:30	11:00		10
3
4
5
6		09:30:00
7		09:40:00
8		09:50:00
9		10:00:00
10		10:10:00
11		10:20:00
12		10:30:00
13		10:40:00
14		10:50:00
15		11:00:00
16
Master

Cell Formulas
Range	Formula
B6:B15	B6	=SEQUENCE((C2-B2+TIME(,10,))/TIME(,10,),,B2,TIME(,E2,))
Dynamic array formulas.

 

[FireBott]

Thank you @Fluff. I just updated that information. I am on 2016. The sequence formula did not work. Thank you

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B	C	D	E
1
2		09:30	11:00		10
3
4
5
6		09:30:00
7		09:40:00
8		09:50:00
9		10:00:00
10		10:10:00
11		10:20:00
12		10:30:00
13		10:40:00
14		10:50:00
15		11:00:00
16
17
18
Master

Cell Formulas
Range	Formula
B6:B18	B6	=IF(B$2+TIME(,E$2,)*(ROWS(B$6:B6)-1)>C$2,"",B$2+TIME(,E$2,)*(ROWS(B$6:B6)-1))

 

[FireBott]

I can't thank you enough. That worked. This will save me at least 3 hours per day during these vaccine times. You are the best

 

[Fluff]

You're welcome & thanks for the feedback.

 

[sam_9020370470]

How can i calculate time fare for example taxi fare

 

[sam_9020370470]

How can i Calculation minute fare in excel.
Eg. If the time starts 09:30:00 end with 14:10:00
I got the hours in time format as 04:40:00.
NP: How can i Calculate formula with these hours to minute. I need to add ₹1 per minutes in these hours. How can i make a formula to convert easily.

 

[Fluff]

This is a totally different question to the original, so you need to start a thread of your own. Thanks