convert seconds to hours minutes seconds

building reports webintelligence
7

That’s a good point.

Changing it the formula below does make it better but there are still a few unexpected results.

Example:
-12,808 seconds gets -04:33:28
-2,204 seconds gets -01:37:44

=FormatNumber(Mod([Time Diff] ;86400)/3600;“00”) + “:” +

FormatNumber(Mod(Mod(Abs([Time Diff]) ;86400);3600)/60;“00”) + “:” +

FormatNumber(Mod(Mod(Mod(Abs([Time Diff]) ;86400) ;3600) ;60);“00”)

Any ideas?