Convert Date Format

[Warrior Golf]

Hi in cell b1 I have "Tue, 10 Apr 2018 09:03:05". The only data I am interested in is the time but would like to change it from military time to AM/PM. How can I keep the time only and eliminate all other data? Please help. Thanks!

<colgroup><col width="349"></colgroup><tbody>
</tbody>

 

[jtakw]

Hi,

This is one way, format cell as Time in the AM/PM format:

Excel 2010
	B	C	D
1	Tue, 10 Apr 2018 19:03:05		7:03:05 PM
Sheet2

Cell Formulas
Range	Formula
D1	=TIMEVALUE(RIGHT(B1,8))

 

[Gerald Higgins]

Hi.

Do you understand how Excel handles dates and times ?

Is the value in B1 entered as a text string, or as a number ?
Put this formula into a cell somewhere . . .
=ISTEXT(B1)
If this returns TRUE, then you've got a text string.
If this returns FALSE, then you've got a number.
Don't worry if b1 is a formula, this could return either a text string or a number and the fact that it's a formula doesn't really matter.

If you've got a number, then it's simple, just apply a different format, such as a TIME format - there is most likely an already existing standard format that will give you what you want.

If you've got text instead of a number, post back, that's solvable too.

 

[Warrior Golf]

Hi,

This is one way, format cell as Time in the AM/PM format:

Excel 2010

	B	C	D
1	Tue, 10 Apr 2018 19:03:05		7:03:05 PM

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula D1 =TIMEVALUE(RIGHT(B1,8)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Worked perfect thanks!

 

[jtakw]

You're welcome.