I’ve got this table:
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! Go to 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")
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")
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |