Extract Time from Data

[chaboyski]

Hi,

just wanted to ask on how i can get the time from the data below:

i would just like to get hh:mm AM/PM

Book1
	A	B	C
1	Date	Time	Data
2	8/1		8/1/23 9:59:17 AM CDT
3	8/1		8/1/23 10:00:57 AM CDT
4	8/1		8/1/23 10:02:22 AM CDT
5	8/11		8/11/23 9:55:37 AM CDT
6	8/11		8/11/23 10:01:46 AM CDT
7	8/11		8/11/23 10:04:18 AM CDT
8	8/11		8/11/23 10:12:23 AM CDT
Sheet1

Cell Formulas
Range	Formula
A2:A8	A2	=DATEVALUE(LEFT(C2,FIND(" ",C2)))

thank you in advance

 

[Tetra201]

See if the following formula works for you:

=TIMEVALUE(SUBSTITUTE(C2," CDT",""))

 

[chaboyski]

yup this works! i tried using =TIMEVALUE(MID(C2,8,4)) but this is much more faster! thank you @Tetra201

 

[Tetra201]

Glad to have helped.