Number To Time Function Needed

[ZulumanatSPI]

I know that Crystal has a Macola NumberToDate conversion function. I need the same thing but for Macola time. So that 105318 comes out to 10:53:18. Does anyone know of a built-in or add-on function to do this?

Thanks.

 

[pgtek]

hi

Try create formula to convert your Macola time number to text
and then use
lefttrim, midtrim and right trim to break it down in 3 section

like
lefttrim{@formula,2}) +":" + midsting{@formula,4}) +":"+
rigthtim{@formula,2})

cheer

pgtek