Time difference - InfoPath Dev
in

InfoPath Dev

Time difference

Last post 04-16-2013 03:15 PM by Asfiti. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-16-2013 02:04 PM

    • Asfiti
    • Not Ranked
    • Joined on 04-16-2013
    • Posts 2

    Time difference

     Hi,

    How do I convert whole number to Time? 

    E.g. I have Time1: 01:20:00 & Time2: 01:25:00

    The result should be: 00:05:00

    I used this formula to get Total minutes= 60 * (substring(Later Time, 12, 2) - substring(Earlier Time, 12, 2)) + (substring(Later Time, 15, 2) - substring(Earlier Time, 15, 2)) + (substring(Later Time, 18, 2) - substring(Earlier Time, 18, 2)) / 60 & the result is Total Minutes in wholenumber

    But, I would like to know how to parse from wholenumber to Time or if I get help to subtract directly & displaying in time format?

    Thanks,

     

  • 04-16-2013 03:15 PM In reply to

    • Asfiti
    • Not Ranked
    • Joined on 04-16-2013
    • Posts 2

     My apologies, the result is in minutes & I need to know how do I convert this into hrs and minutes? any help is appreciated.

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.