Forum Stats

  • 3,781,540 Users
  • 2,254,529 Discussions
  • 7,879,749 Comments

Discussions

Percentage completion calculations

Tina
Tina Member Posts: 247 Blue Ribbon

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

Answers