Date and Time Stamp_How to change 12hrs into 24hrs?

Hi Everyone

Does anyone know how to (if possible) change the date and time stamp into 24hrs?Change to 24hrs.jpg

Solved Solved
1 3 153
1 ACCEPTED SOLUTION

Uk
Silver 1
Silver 1

may be you can try this one

TEXT(TIME([Date Time Entered]),โ€œHH:MMโ€)

View solution in original post

3 REPLIES 3

Uk
Silver 1
Silver 1

may be you can try this one

TEXT(TIME([Date Time Entered]),โ€œHH:MMโ€)

I agree with @Uk . This would be done in a virtual column, by the way.   

I'll give it a go. thank you! 

Top Labels in this Space