How to generate Start Time

[alvinford]

Hi All,

Facing issue with the time. Need to generate the start time based on the end time and duration.

I have event end time as 00:20:00 (hh:mm:ss) and Duration as 3:20:00(hh:mm:ss).

How can I get the Start Time i.e 09:00:00.

Request your help.

Thanks in Advance.

Regards,

Alvin.

[Gysbert_Wassenaar]

EndTime - Duration should give you the start time, 21:00:00 (or 09:00:00 PM) in your case, not 09:20:00. Make sure you work with dates and times, not strings. Use the date# and time# functions if necessary to create dates and times from strings.

[er_mohit]

hiii...

Interval(time(endtime,'hh:mm:ss')-Time(Duration,'hh:mm:ss'),'hh:mm:ss') as Start_Time

[#4]

= interval (Time(Time#('12:20:00','hh:mm:ss')) - interval(Time(Time#('3:20:00','hh:mm:ss'))-Time(Time#('0:20:00','hh:mm:ss')),'hh:mm:ss'),'hh:mm:ss')

Bold - Specify hr's format. If you use 12hr Format Specify 12, else 24.

Hope this helps

[alvinford]

Thanks Gisbert I have rectified the output value.

Regards,

Alvin.

[alvinford]

Hi Mohit,

Its not giving the desired results.

Regards,

Alvin.

[alvinford]

Hi Streak,

I can't catch up your logic. I have added the sample data in the Excel with columns EndTime and Duration. Can you please help to achieve StartTime.

Please find the  attachment.

Regards,

Alvin.

[#8]

Copy the expression and put inside the text object, you will see what your

are expecting.

[alvinford]

Hi Streak,

I have already verified that.Can't get the expected values.

Regards,

Alvin.

[alvinford]

Can you please help ...

Regards,

Alvin.