Get only time from a Data Time string

[MK9885]

Hi,

How can I get only time from below field?

I just want 11:35 or 12:25 etc
I used Time# and other functions but doesn't work.. maybe because this string has YYYY-MM-DD HH:MM:SS and then some 000000...
Those 0000's in the end doesn't give me correct time. I just get time as 00:00.

[PriyankaShivhare]

Time(Frac(DateTimeField),'hh:mm')

[MayilVahanan · Accepted solution]

Hi @MK9885 

I think, your field in string format, try like below

=mid('2020-10-12 11:35:00.0000', 12, 5)

Mid(urtimestampfield, 12, 5) 

[MK9885]

Thanks Mayi
Mid(urtimestampfield, 12, 5)  << worked