14 Replies Latest reply on Oct 13, 2016 9:44 PM by Mahfooj Khan

    Convert [h]:mm in excel cell into decimal number in Tableau

    Maziiar Abadi

      I have an excel spread sheet and need to create a report based on that in Tableau. Below is example of my data set:

      Header 1
      19:15   
      250:29  
      74:24   
      3:40    
      0:14    
      -36:27  
      1953:29 
      19:15   
      253:38  
      539:51  

      Which are [h]:mm and needs to be converted to workdays (8 hours).

      Could anyone help me how to do that without manual formatting in excel.