Error Building A String With Date and Time Formatting

[Ark68]

I am trying to create a text string from the values in 3 cells.

Catalogue12296.xlsm
	P	Q	R	S	T
2	Lilie 2	06-Mar-02	0:06:17	1	#NAME?
DUMP

Cell Formulas
Range	Formula
Q2:R2	Q2	=D2
T2	T2	=S2 & " - " & P2 & " [" & format(Q2,"yy-mmm-dd") & " " &R2& "]"

I am looking to achieve this string in T2

1 - Monster [06-Mar-02 0:06:17]

I am getting a #NAME error with this formula.

Note: I feel I have the value in R2 represented (formatted) wrong. It's showing as a time, 0:6:17 is 12:10:17 am. It really is supposed to represent duration, ie 0:06:17 is supposed to represent 6 minutes and 17 seconds. Please help me correct this as well if it is indeed wrong.

 

[Cubist]

Use TEXT.
FORMAT doesn't exist for formulas.

Book3
	P	Q	R	S	T
1
2	Lilie 2	3-Mar-02	0:06:17	1	1 - Lilie 2 [02-Mar-03 0:06:17]
Analysis

Cell Formulas
Range	Formula
T2	T2	=S2 & " - " & P2 & " [" & TEXT(Q2,"yy-mmm-dd") & " " &TEXT(R2,"[h]:mm:ss")& "]"

 

[HighAndWilder]

I am trying to create a text string from the values in 3 cells.

Catalogue12296.xlsm
	P	Q	R	S	T
2	Lilie 2	06-Mar-02	0:06:17	1	#NAME?
DUMP

Cell Formulas
Range	Formula
Q2:R2	Q2	=D2
T2	T2	=S2 & " - " & P2 & " [" & format(Q2,"yy-mmm-dd") & " " &R2& "]"

I am looking to achieve this string in T2

1 - Monster [06-Mar-02 0:06:17]

I am getting a #NAME error with this formula.

Note: I feel I have the value in R2 represented (formatted) wrong. It's showing as a time, 0:6:17 is 12:10:17 am. It really is supposed to represent duration, ie 0:06:17 is supposed to represent 6 minutes and 17 seconds. Please help me correct this as well if it is indeed wrong.

Does this work?

Book1
	O	P	Q	R	S	T
1
2		Lilie 2	06/03/2002	00:06:17	1	1 - Lilie 2 [06-Mar-02 0:06:17]
3
Sheet1

Cell Formulas
Range	Formula
Q2:R2	Q2	=D2
T2	T2	=S2 & " - " & P2 & " [" & TEXT(Q2,"dd-MMM-yy") & " " & TEXT(R2,"H:MM:SS") & "]"

 

[Ark68]

Thank you both for the solution!
If I were writing this formula in VBA, then would I use "Format"?

 

[HighAndWilder]

Thank you both for the solution!
If I were writing this formula in VBA, then would I use "Format"?

Yes, that is right.