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!

How to calculate the sum of some values hh.mm in a Apex's classic report

Neruda from ItalyNov 3 2016 — edited Nov 17 2016

Hello. In an application I must handle the duration of working hours of some users. I can handle these values in two ways:

1. Inserting "Start (hh:mm)", "End (hh:mm)" and then calculate the difference (hh:mm) between these values (Example A)

2. Inserting the duration expressed in minutes (Example B)

Immagine.png

If a classic report in Apex the option "Compute SUM" for a numeric table's column would give me the sum expressed in a numeric value, for example 1130 that equals to 18hh 50mm but I need to show this sum expressed in hh:mm as you can see in the two examples above. Is it possibile to do this in the report?

Thank you for your help

This post has been answered by fac586 on Nov 5 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2016
Added on Nov 3 2016
13 comments
2,559 views