Using Concatenate with Time

rlw989

New Member
Joined
Sep 16, 2006
Messages
5
I have a sheet that I want to enter the start time and end time of an event.

IE:
Start Time : 6:30
End Time: 10:30

I want to use concatenate to produce a column of cells with a time range in each row IE:
6:30 - 6:45
6:45 - 7:00
7:15 - 7:30
..........

All the cells are formated customer with h:mm

I tried to use this code =concatenate(Start Time Cell, " - ", Start Time Cell + 15)

But this does not work. By start time cell I simply mean the cell in which I entered the start time and then I want to add 15 minutes to that until I reach the end time.

Any ideas?
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,838
Hi rlw989
Welcome to the board

With Start date in A1, please try:

Code:
=TEXT(A1,"h:mm")&" - "&TEXT(A1+"0:15","h:mm")

Hope this helps
PGC
 

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
Hey pgc01,
Thanks for this. This just saved me a lot of time trying to figure out a similar problem.
You rock.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,360
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top