Sage 100

 View Only
  • 1.  Update time format - in many files there is an upd

    Posted 01-22-2016 10:53
    Update time format - in many files there is an update time format like 22.27385. How does this convert, if it does, to HH:MM:SS?


  • 2.  RE: Update time format - in many files there is an upd

    Posted 01-22-2016 11:16
    it is the decimal time if you multiple the Decimal reminder by 60 you can convert to minutes and seconds respectively. .27385 * 60 you convert to minutes. same with the seconds. .27385 * 60 = 16.431 minutes .431* 60 = 25.86 seconds so 22:16:25.86


  • 3.  RE: Update time format - in many files there is an upd

    Posted 01-22-2016 12:14
    Awesome thank you @JimWoodhead