"After spending many hours digging through long PL/SQL functions on the database I could see nothing wrong with the logic. Even more confusingly, the files I generated myself showed the correct times."
"Our files were output to their specifications, which called for billable time to be expressed in minutes. The user had divided the number by 100 as it looked 'too large' and they wanted the number in hours."
"I had to explain to the user that to get billable time in hours you must divide by 60 not 100. And that's why the numbers were out by about a third!"
A software engineer named Albert faced an urgent support ticket regarding inaccurate billable hours in an Excel spreadsheet linked to Oracle ERP. After thorough investigation, he discovered the user had manually altered the spreadsheet's calculations. The user divided the billable time by 100 instead of the correct factor of 60, leading to a one-third discrepancy in the results. Albert clarified the correct method for calculating hours, resolving the issue.
Read at Theregister
Unable to calculate read time
Collection
[
|
...
]