Transform to Time

[pgalvezt]

Hi! Please I need your help, I would like to transform my formula to time hh:mm:ss. I've tried with time, Interval and TimeStamp, but its not working. I´ve attached my qv file.

Thanks!

[CELAMBARASAN · Accepted solution]

Hi,

     Try with this using mod function

     Time#(Floor(SumOfSum_DiferenciaCL/60) & ':'& Mod(SumOfSum_DiferenciaCL,60),'h:m')

Celambarasan

[pgalvezt]

Finally works many thanks!