Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nuwanhwb87
Contributor III
Contributor III

How to Calculate Duration from Two Times

03.PNG

Hi,

I have Above table with IN Time and Out Time.

Need to calculate total Duration

Out Time - In Time

Specially How to Extract the time from Above Date Format

Labels (1)
2 Replies
Anil_Babu_Samineni

Perhaps this

Date(Date#(IN_TIME, 'DD/MM/YYYY HH:MM:SS TT')-Date#(OUT_TIME, 'DD/MM/YYYY HH:MM:SS TT'), 'HH:MM:SS')

Or

Interval(Date#(IN_TIME, 'DD/MM/YYYY HH:MM:SS TT')-Date#(OUT_TIME, 'DD/MM/YYYY HH:MM:SS TT'), 'HH')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nuwanhwb87
Contributor III
Contributor III
Author

Hi,

thanks for quick reply,

Unabel to run first code in PL/SQL Developer Error Message Emerge (ORA-00936 Missing Expression)