Help

Column with only hour

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
911 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JeremiBen
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone, 

I have a data base with activities wher date and time are fulfilled but I would like to show only the hour in one column.

I'm unable to display what i want. 

I have for example one column with ISO 14/12/2023 1:52 and i would like two different columns with 14/12/2023 and another one 13:52

 

Thank you for your help !

1 Solution

Accepted Solutions
BillH
9 - Sun
9 - Sun

I believe if you add a new formula field with the formula as 

RIGHT(CONCATENATE("00",HOUR({Last Modified})),2)&":"&RIGHT(CONCATENATE("00",MINUTE({Last Modified})),2)
using your datetime field instead of Last Modified you will get the display for the time (based on GMT since that is what the HOUR function uses).

See Solution in Thread

2 Replies 2
BillH
9 - Sun
9 - Sun

I believe if you add a new formula field with the formula as 

RIGHT(CONCATENATE("00",HOUR({Last Modified})),2)&":"&RIGHT(CONCATENATE("00",MINUTE({Last Modified})),2)
using your datetime field instead of Last Modified you will get the display for the time (based on GMT since that is what the HOUR function uses).
JeremiBen
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you Bill !