1 Reply Latest reply on Dec 12, 2013 12:09 PM by Tracy Rodgers

    Combining Hour and Minute columns to display correct time?

    Mark ODonnell

      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":
        • DATETIME([Hours]+":"+[Minutes])
      • Then I set the date format as custom, HH:MM.

       

      When I place this on the workbook I get a bunch of nulls.

      time.jpg

       

      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.

      Thanks in advance...