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.

Comments

  • gpigpi
    edited 9:49PM
    1. Convert all hours, minutes to seconds (hh*3600 + mm*60 +ss)
    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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.