Converting Seconds to Minutes?

[Wenin]

Does Crystal come with a function that allows the easy conversion of Seconds to minutes? I am needing to run reports from a database that is storing its times in Seconds.

I'd like to avoid, but may have to just accept the fact that I'll need to come up with my own conversions.

 

[Wenin]

Found this answer through a few searches.

numbervar sec:={your.seconds.field};

stringvar mins;
stringvar secs;

mins:=totext(truncate(sec/60),"0");
secs:=totext(remainder(sec,60),"00");

mins +":" + secs

Gave the guy a star to! =)