1 Reply Latest reply on Feb 6, 2014 9:08 AM by Magus069

    How do I display a time difference as hours and minutes vs. a decimal?

    catetr

      Here's what I'm working with:

       

       

      Total1

      =(((Time2Num(Arrive1.formattedValue, "h:MM A")-Time2Num(Start1.formattedValue,"h:MM A"))+(Time2Num(Arrive2.formattedValue, "h:MM A")-Time2Num(Depart1.formattedValue,"h:MM A"))+(Time2Num(Home1.formattedValue, "h:MM A")-Time2Num(Depart2.formattedValue,"h:MM A")))/((1000*60)/

      60))

       

      However, the total is displayed as 1.5, and I need it to be 1:30, for example. Thanks!