Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Time Duration addition in Apex

User484193-OCNov 3 2020

Dear Team,
I have 5fields i.e., Log1,Log2...Log5 and Total Log=Log1+Log2+Log3+Log4+Log5 and its datatype is varchar2
i am entering data as 2:30,2:30,4:00,3:00,5:00=16:60 but as per time we need to get 17
i am using normal form and the total hours is calculating dynamically before saving into db.
please help me out on this.
time.JPG

This post has been answered by hari-Oracle on Nov 3 2020
Jump to Answer
Comments
Post Details
Added on Nov 3 2020
9 comments
477 views