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 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.