4 Replies Latest reply on Dec 21, 2012 9:43 AM by Shawn Wallwork

    Converting HHMM Military time to 12hr Time without Mod func

    Ryan Kaspar

      Currently I have a time field from a DB2 / iSeries system that captures time in HHMM.   We'll call it [APPTTM].  It is a military format (24 hr).

       

      In excel, I can run calculations using Mod to convert to a usable time format.

       

      =ROUNDDOWN([APPTTM],-2)/2400+MOD([APPTTM],100)/1440

       

      RoundDown and Mod do not appear to the be viable functions in Tableau.  Is there an equivalent?

       

      The end goal is to combine the time field with a pre-calculated date field to form a datetime, but I can handle that part.