How to extract the time of a time stamp cell?
Is there anyway to extract the time portion of a time stamp field? I’ve tried several expressions with no luck… I would prefer to use this in a virtual column rather than an actual column.
Add a formula [TimeStampColumn] into the virtual column and change the column’s type to Time.
@praveen I think this has been asked before…
Formula suggestion: TIME([DateTime])
And of course one for date too.
@Aleksi_Alkio Thanks Aleksi Translate
User | Count |
---|---|
39 | |
26 | |
22 | |
20 | |
15 |