none
Find Interval Between Time

    Question

  • Hi all,

    I am trying to find interval between two times.

    eg.

    I have two time fields

    1. 10:15:00 PM

    2.12:15:00 AM

    i want output  11:15,12:15 like these time interval

    So please help me..

    Regards,

    GK

    Tuesday, April 08, 2014 11:19 AM

All replies

  • By two time fields do you mean two different attributes ?

    Could you please elaborate.


    Saurabh Kamath


    • Edited by S Kamath Tuesday, April 08, 2014 6:32 PM
    Tuesday, April 08, 2014 6:32 PM
  • Hi Saurabh,

    Thanx for reply..

    yes i have 2 attributes

    1. first attribute eg. 10:15:00 PM

    2. second attribute eg. 12:15:00 AM

    Regards,

    GK

    Wednesday, April 09, 2014 5:50 AM
  • Your question is not so clear..Kindly elaborate.

    Wednesday, April 09, 2014 5:53 AM
  • hi Rahul,

    Please check following eg...

    Field1    Field2    Required output             Diff hr

    10:15    13:15    11:15, 12:15, 13:15          3hr

    11:15    12:15    12:15                                1hr

    13:15    16:15    14:15, 15:15, 16:15          3hr

    As shown in given eg. i have field 1 and field2 and i want output as required field

    I hope you understand on above table..

    Regards,

    GK

    Wednesday, April 09, 2014 6:42 AM