Combine parts of two cells in a new cell.

[gbr400m]

Need you help please:

I need to come parts of two cells to create a label in a new cell

Column E; Row 4
7:00 (Time)
Column H, Row 4
4 (Length)

Desired Label in new cell would read
07-4 (Start Time - Length)

I need the
Hour start time with a dash then the length.

Help please!:)

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[gbr400m]

Workbook attached with the examples.

Desired outcome is shown in cell A4

Excel Shift Labels.xlsx

[Jul Stev]

what do you want it to show if the start time is 07:30?

Please Login or Register  to view this content.

this formula will work for 07:00

[Ghozi Alkatiri]

=text(hour(e4),"00")&-h4

[gbr400m]

It would need to show 073-4

[sktneer]

Does this help.....

=TEXT(G5,"HH")&TEXT(E5,"H")&"-"&H5

[Jul Stev]

try this..

Please Login or Register  to view this content.

[gbr400m]

Wow you folks are seriously geniuses! Thank you the formula's worked perfectly.

I ended using Jul Stev formula
=CONCATENATE(TEXT(E16,"hh")&IF(MINUTE(E16)=0,"",LEFT(MINUTE(E16),1))&"-"&H16)

So now my next question.
In Column B I have two descriptions 'Extra Shift' and 'CWW'

How can I expand on the formula provide to a 'x' in front of an extra shift or a 'w' in front of a 'CWW'

Thanks!

[Jul Stev]

try..

Please Login or Register  to view this content.

[gbr400m]

Perfect Thank you!

[Jul Stev]

No problem, glad i can help