I have a 2 columns in my data, one for Hour and one for Minute, both string values. I am seeking some help on a way to combine them so that they show as the correct HH:MM when I place them in a workbook.
So far I have tried creating a calculated column named "Time":
Then I set the date format as custom, HH:MM.
When I place this on the workbook I get a bunch of nulls.
As an added bonus I would love to know how to turn this into a decimal display also, so 1:30 shows as 1.5.