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 |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |