This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to extract the time of a time stamp cell?...

Posted on 02-01-2018 04:00 PM
Michael2
New Member
Reply posted on --/--/---- --:-- AM

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.

0 3 373
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
Aleksi_Alkio
New Member
Reply posted on --/--/---- --:-- AM

Add a formula [TimeStampColumn] into the virtual column and change the columnโ€™s type to Time.

0 Likes

Posted on --/--/---- --:-- AM
MultiTech
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

@praveen I think this has been asked beforeโ€ฆ

Formula suggestion: TIME([DateTime])

And of course one for date too.

0 Likes

Posted on --/--/---- --:-- AM
Michael2
New Member
Reply posted on --/--/---- --:-- AM

@Aleksi_Alkio Thanks Aleksi Translate

0 Likes
Top Labels in this Space