Have employees' hours added up

[JeremiBen]

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 !

[BillH · Accepted solution]

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]

Thank you Bill !