Skip to main content
Solved

Column with only hour

  • December 14, 2023
  • 2 replies
  • 131 views
Forum|alt.badge.img+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).
View original
This topic has been closed for replies.

2 replies

BillH
Forum|alt.badge.img+24
  • BillH
  • Brainy
  • Answer
  • December 14, 2023

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).
    Forum|alt.badge.img+6
    • JeremiBen
    • Author
    • Inspiring
    • December 20, 2023

    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 !

    Terms & ConditionsAccessibility statement