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!

[Anonymous]

Hi,

what is the field name that you are trying to convert?

[pgalvezt]

Hi,

The Expression is (SumOfSum_DiferenciaCL/60) & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60). And this I need to pass To Time. For example: Sumof sum 18 that number I have to convert to time. In my Excel file I have: =INT(C2/60)&":"&INT(((C2/60)-INT(C2/60))*60),

so the number 18 is converted to 0:18.

[CELAMBARASAN]

Hi,

     Did you tried with Time#?

     Time#(SumOfSum_DiferenciaCL/60) & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60,'h:m')

Hope it helps

Celambarasan

[pgalvezt]

Hi, thanks for your reply but Still is not working

Time#(SumOfSum_DiferenciaCL/60,'h:m') & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60).

[CELAMBARASAN]

Hi,

    Paranthesis problem in previous post check the below expression.

     Time#((SumOfSum_DiferenciaCL/60) & ':'& ((SumOfSum_DiferenciaCL/60) - (SumOfSum_DiferenciaCL/60)*60),'h:m')

Celambarasan

[pgalvezt]

Hi, Still not working. I´ve tried with format number but nothing happened.

[pgalvezt]

Any help?

Thanks!

[CELAMBARASAN]

Hi

     I think it returns decimal values.

     Check with this

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

Hope it helps

Celambarasan

[pgalvezt]

Thank you for your reply. Almost ready. but I think is not working yet. The idea is emule the excel file. I´ve attached the excel file for better comprehenssion.

Thanks