Change Hour Formats and Sum Hours
Hi guys i need some help..
I am using an Anviz CrossChex aplication to generate some report.
When i generate the report all the data who are in hh:mm:ss it converts to decimal and calculate some values in the report...
The thing is that i need to have all the data which are shown in the yellow rectangle of the attached images it is shown in the format hh:mm:ss and the totals are shown too in that format.
How can i do it??
Or if i attached the report can someone convert me the file plz???
Thanks!
P.D: Sorry for my english but im an Spanish native user.
I am using an Anviz CrossChex aplication to generate some report.
When i generate the report all the data who are in hh:mm:ss it converts to decimal and calculate some values in the report...
The thing is that i need to have all the data which are shown in the yellow rectangle of the attached images it is shown in the format hh:mm:ss and the totals are shown too in that format.
How can i do it??
Or if i attached the report can someone convert me the file plz???
Thanks!
P.D: Sorry for my english but im an Spanish native user.
Comments
2. Calc totals
3. Convert seconds to hours, minutes, seconds
seconds div 3600 as hours
(seconds - hh * 3600) div 60 as minutes
seconds - hh * 3600 - minutes * 60 as seconds