6 Replies Latest reply on Jan 24, 2019 3:04 AM by Prasanna R

    Assistance with how to define a "target time stamp" for a specific period of the day

    LanceCM Martens

      Hi All,

       

      I would appreciate any assistance with the following calculated fields.

       

      Context,

      • I have two daily "target start times"
      • The first is at 6:35 AM
      • The other is at 4:20 PM

       

      • I then have a count in minutes (After Start Time Target Measure), namely the minutes elapsed after the target time.

       

      Logic,

      • Example as follows
      • Start Target Time set for 6:35 AM
      • Time elapsed after Start Time logged as 25 (unit in minutes)
      • Therefore "Actual Start Time" is 7:00 AM

       

      Required,

      1. All I need is a way to establish two calculated fields, each will enable me to define a fixed time stamp for a specific time of the day

       

      • The first calculated field needs to be titled 6:35 AM Target Start Time
      • The next calculated field needs to be titled 4:20 PM Target Start Time

       

      • Typically if I were to introduce the calculated field into a table, one would show up as 6:35 AM and the other as 4:20 PM

       

      Any assistance would be most appreciated,

       

      Regards,

      Lance