3 Replies Latest reply on Dec 8, 2016 8:18 AM by paolo.raia

    Converting decimal time to hours and minutes

    paolo.raia

      Hi,

       

      I have decimal time that I wish to convert to hours/minutes.  For example, 1.5 should read as 1hr 30mins.  Example table, below:-

      I started to create a function calculation involving STR(INT(FIND(MID etc etc, then wondered if there was a simpler approach.

       

      Many thanks in advance.