Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).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.
hiii...
Interval(time(endtime,'hh:mm:ss')-Time(Duration,'hh:mm:ss'),'hh:mm:ss') as Start_Time
= 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
Thanks Gisbert I have rectified the output value.
Regards,
Alvin.
Hi Mohit,
Its not giving the desired results.
Regards,
Alvin.
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.
Copy the expression and put inside the text object, you will see what your
are expecting.
Hi Streak,
I have already verified that.Can't get the expected values.
Regards,
Alvin.
Can you please help ...
Regards,
Alvin.