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

This topic has been closed for replies.

+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