Solved

Column with only hour

+6

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 !

Best answer by BillH

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).

+24

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).

+6

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).

Thank you Bill !

Sign up