Remove seconds from time

I’ve got this table:
3X_5_7_57f34d1b5ef4f80429b9e9962e96ddc48b91f517.png
The ‘Date’ is set to long format and the ‘Start’ and ‘Stop’ times are set to ignore seconds

And am trying to maintain the format when I concatenate the 3 columns. Apparently the switches for long format and ignore seconds are not maintained when you concatenate. I’ve got this working:
CONCATENATE(INDEX(LIST("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"),MONTH([Date]))," ",DAY([Date])," ",[Start],"-",[Stop]) but am having difficulty removing the seconds in the ‘Start’ and ‘Stop’ columns. Hours() seems to only apply for duration but I want the hour and minutes of the actual time, not of the time duration.

Solved Solved
0 2 2,947
1 ACCEPTED SOLUTION

@Tom_automated
This expression will be even shorter to achive the same result

TEXT([Date],"MMM DD")&" "&TEXT([Start],"HH:MM")&"-"&TEXT([Stop],"HH:MM")

View solution in original post

2 REPLIES 2

CONCATENATE(
    INDEX(
        LIST("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"),
        MONTH([Date])
    )," ",
    DAY([Date]),
    " ",
    TEXT([Start],"HH:MM")
    ,"-",
    TEXT([Stop],"HH:MM")
)

@Tom_automated
This expression will be even shorter to achive the same result

TEXT([Date],"MMM DD")&" "&TEXT([Start],"HH:MM")&"-"&TEXT([Stop],"HH:MM")

Top Labels in this Space