0 - 2 of 2 tags for time difference

Hello All,
THe below query is to find the difference between Previous Hour Time - Minutes to get the beginning of the previous hour.
SEL CAST(CAST(CURRENT_TIME AS FORMAT 'HH:MI') AS CHAR(8)) - EXTRACT(MINUTE FROM(CAST(CAST(CURRENT_TIME AS FORMAT 'MI:SS') AS CHAR(5)))) (TITLE 'OUTPUT')
 

Hi All,

I have a business requirement for my client ono of the table have two Timestamp(6) fields

'Startdatets' and 'Enddatets' from this want to generate elapsed time report in HH:MM formate

which should not contain non business days hours like Saturdays, sundays and Holidays.

ex: