TerryBurger
asked on
Help with simple crystal formula. Seconds to hours:min
Hi, I have a field in second, and I need to convert it to hours:min. Here is what I want to do:
shared Numbervar hrs = int({pkdaily;1.dtdur} / 3600)
shared Numbervar min = int({pkdaily;1.dtdur} / 60) - (hrs*60))
if min = 60 then
min = 0
hrs = hrs + 1
return totext({pkdaily;1.dtcalls} ,0) + " (" + totext(hrs) + ":" + totext(min) + ")"
How do I make the formula work in Crystal?
Thanks,
Terry
shared Numbervar hrs = int({pkdaily;1.dtdur} / 3600)
shared Numbervar min = int({pkdaily;1.dtdur} / 60) - (hrs*60))
if min = 60 then
min = 0
hrs = hrs + 1
return totext({pkdaily;1.dtcalls}
How do I make the formula work in Crystal?
Thanks,
Terry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BTW, what is the datatype of {pkdaily;1.dtcalls}?
Looks good.
mlmcc
mlmcc
ASKER
Works great guys, thanks!