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

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

• ###### 1. Re: Assistance with how to define a "target time stamp" for a specific period of the day

As a start, is there a way to fix the start time target, the same way I do with a height target?

Example,

• Height Target = 2000 m
• I can define the "height target" by simply typing in 2000 into a calculated field, and defining the measure as "Avg." to use it in any calculation

• Can I do the same for a target that is a "Time Function"?
• ###### 2. Re: Assistance with how to define a "target time stamp" for a specific period of the day

Hi Lance,

You can use the MakeTime function that will help you create a fixed time stamp. If you want to add date as well then you can use Makedatetime function.

• ###### 3. Re: Assistance with how to define a "target time stamp" for a specific period of the day

Guess you can create another time stamp just like this for 4.20 PM.

Please let me know if this helps.

• ###### 4. Re: Assistance with how to define a "target time stamp" for a specific period of the day

Hi Prasanna,

However, I can't seem to get my Calculated field to recognize the "MAKETIME" syntax

1 of 1 people found this helpful
• ###### 5. Re: Assistance with how to define a "target time stamp" for a specific period of the day

I believe then you are having a live connection. You need to have the connection as extract to get certain functions to perform. MakeDate, MakeTime, MakeDateTime can be used only in Extract connection

• ###### 6. Re: Assistance with how to define a "target time stamp" for a specific period of the day

Awesome, it works great!

Thanx for the support Prasanna, you're a legend mate!

Regards,

Lance

• ###### 7. Re: Assistance with how to define a "target time stamp" for a specific period of the day

Happy to help.. Sure you are going to be helping others pretty soon..