Calculation of actual hours with start date and end date

[Priyanka]

Can anyone please let me know how to calculate the actual hours with the help of start date and end date.

I have  attached the script below,

Project:
LOAD
id as project_id,
project_name,
project_status,
base_project,
description,
client_id,
currency_id,
project_type,
lead_approve_ts,
estimated_hrs,
start_date,
end_date,
initiated_date,
hold_date,
completed_date,
is_active as is_project_active
FROM [lib://Data/Project.qvd]
(qvd);

Thanks in advance..

[Simon_Astakhov]

I don know whit formats and values inside, but typical solution is:

Generate table with hours from 0 to 24;

Make intervalmatch() join like in help.

IntervalMatch