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>
[TD="class: xl63, width: 349"][/TD]

</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
Tue, 10 Apr 2018 19:03:05

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"]7:03:05 PM[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D1[/TH]
[TD="align: left"]=TIMEVALUE(RIGHT(B1,8))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Worked perfect thanks!

 

[jtakw]

You're welcome.