Percentage completion calculations

Tina

Hi Gurus,

I am trying to calculate percentage completion for a process.

I have expected_end_time and start_time for that process.Is there any formula we can use to get percentage remaining based on these dates?

SELECT TO_DATE('11/23/2021 10:31:12 PM','MM/DD/YYYY HH:MI:SS AM') AS EXPECTED_END_TIME,

    TO_DATE('11/23/2021 10:00:00 PM','MM/DD/YYYY HH:MI:SS AM') AS START_TIME,

    (TO_DATE('11/23/2021 10:31:12 PM','MM/DD/YYYY HH:MI:SS AM')- TO_DATE('11/23/2021 10:00:00 PM','MM/DD/YYYY HH:MI:SS AM'))*24*60 diff_in_min

FROM DUAL; 

Thanks

User_H3J7U

100*greatest(least(1-(sysdate-START_TIME)/nullif(EXPECTED_END_TIME-START_TIME, 0), 1), 0)