displaying time +20 minute increments

[moonoverparadise]

I need to create a formula to add 20 minutes to a start time....
what i want it to look like is this:

7:30 a.m. to 7:50 a.m.
7:50 a.m. to 8:10 a.m.
8:10 a.m. to 8:30 a.m. and so on............

Could someone help please?

 

[Lee.]

=a1+time(0,20,0)

 

[moonoverparadise]

i will need to display in the cell such as this though....

7:30 a.m. to 7:50 a.m.
7:50 a.m. to 8:10 a.m.
8:10 a.m. to 8:30 a.m. and so on............

 

[thatoneguy650]

Excel Workbook
	A	B
1	Start Time	Formatted Time
2	7:30 AM	7:30 AM to 7:50 AM
3	7:50 AM	7:50 AM to 8:10 AM
4	8:10 AM	8:10 AM to 8:30 AM
Sheet1

 

[Momentman]

Maybe like this,

Excel 2010
	A	B
1	07:30	07:30 AM to 07:50 AM
2	07:50	07:50 AM to 08:10 AM
3	08:10	08:10 AM to 08:30 AM
4	08:30	08:30 AM to 08:50 AM
5	08:50	08:50 AM to 09:10 AM
6	09:10	09:10 AM to 09:30 AM
7	09:30	09:30 AM to 09:50 AM
8	09:50	09:50 AM to 10:10 AM
9	10:10	10:10 AM to 10:30 AM
10	10:30	10:30 AM to 10:50 AM
11	10:50	10:50 AM to 11:10 AM
12	11:10	11:10 AM to 11:30 AM
13	11:30	11:30 AM to 11:50 AM
14	11:50	11:50 AM to 12:10 PM
15	12:10	12:10 PM to 12:30 PM
16	12:30	12:30 PM to 12:50 PM
Task

Cell Formulas
Range	Formula
B1	=TEXT(A1,"hh:mm AM/PM")&" to "&TEXT(A1+20/60/24,"hh:mm AM/PM")
A2	=A1+20/60/24

 

[Lee.]

=TEXT(A1,"HH:MM AM/PM") & " to " & TEXT(A1+TIME(0,20,0),"HH:MM AM/PM")