tegronakron
asked on
crystal reports sum up date fields in format DD:HH:MM:SS
I am trying to find the sum of the downtime in format DD:HH:MM:SS
Here is what i currently have:
Totext({#SecondsTotal}/864 00,'00')
& ":" &
Totext(Remainder({#Seconds Total},864 00) ,'00')
& ":" &
Totext(Remainder({#Seconds Total},360 0),'00')
& ":" &
Totext(Remainder({#Seconds Total},60) ,'00')
The problem is that it is not rolling up the leftover seconds to the minutes column, hours, and days.
I read somewhere about adding these in but I dont know how to do it.
Here is what i currently have:
Totext({#SecondsTotal}/864
& ":" &
Totext(Remainder({#Seconds
& ":" &
Totext(Remainder({#Seconds
& ":" &
Totext(Remainder({#Seconds
The problem is that it is not rolling up the leftover seconds to the minutes column, hours, and days.
I read somewhere about adding these in but I dont know how to do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help.
ASKER
Thanks