4 Replies Latest reply on Oct 7, 2018 8:39 AM by Mahfooj Khan

    Time format issue

    Venkatesh Raju

      Dear Experts,

       

      I am working on a dashboard and struck with an issue in tableau, need Experts advice please.

       

      I have a excel data source and which has Date column separately and Time column separately. I am using a calculative filed mentioned below to make it Date&Time field.

      DATETIME(STR([Date]) +" "+STR([LoginTime]) + ":00")

      Problem is time is consodered as 12 hours (1:15:00 PM) format which i want it to be 24 hours format 13:15:00). I tried to format the calculative field to custom format but still  its not changed. due to which one of my calculation is showing wrong results.

       

      Unable to attach the workbook due to company policy need experts advice please to fix the issue.