4 Replies Latest reply: Jun 18, 2015 9:09 AM by Martin Čevela RSS

    QlikView date format for elapsed times


      I'm trying to show an elapsed time (timestampB - timestampA) and I have troubles getting with the correct format to use for values greater than a day. For example, if the elapsed time is 26 hours and 15 minutes I'll like to show "26:15:00" or "1 02:15:00". In Windows the format is "[ h ]:mm:ss" but it doesn't work in QlikView. Any ideas?