topic Re: Calculating time difference between date and time stamps in QlikView

Calculating time difference between date and time stamps

isciberras — Sat, 16 Nov 2024 19:17:30 GMT

Hi,

I am having an issue with a combined date and time stamp.

Basically all I want to do is calculate (In hours) the time difference between a start day&time stamp and the end of the day&time stamp.

All start and end times are differentiated by a reference number.

I researched in the Qlik community and tried different solutions however, even when QlikView returns a result it will still return a number which is not the correct amount of hours between a start and an end time.

I attached an example of what I am trying to achieve

Re: Calculating time difference between date and time stamps

rubenmarin — Thu, 16 Jan 2020 16:44:14 GMT

Hi, Timestamp#() is used to tell the format of the timestamp that is being readed, so in this case it should be 'DD/MM/YYYY hh:mm' (note that time letters are lowercase: MM for months, mm for minutes), so the final table shoud be:

Main: load *, interval(Timestamp#([End Date],'DD/MM/YYYY hh:mm') - Timestamp#([Start Date],'DD/MM/YYYY hh:mm'),'hh:mm') as [Time difference] Resident Staging;

Re: Calculating time difference between date and time stamps

Brett_Bleess — Wed, 12 Feb 2020 22:09:18 GMT

Did Ruben's post get you what you needed? If so, do not forget to return to your thread and on his post, use the Accept as Solution button to mark his post as the solution and given him credit for the help as well as let other Members know it worked. If you are still working on things, leave us an update on what you still need.

Regards,
Brett