Sum Time

[pgalvezt]

Hello!

I would like to know how to sum time. i left a example of What I want to do. I´ve tried with:

Interval(sum(myfield)) but its not working.

Thanks!

[rohit214 · Accepted solution]

Hi

Please find the attachment.

Thanks

rohit

[Anonymous]

Hi there, 

if your time field (Tiempo) is in DateTime format you could do the following in your expression.

LEFT(DATE(Tiempo,'hh:mm'),2)*60 + RIGHT(DATE(Tiempo,'hh:mm'),2)

This will convert the hours to minutes then add this result and the minutes together.

ie: 10:35  = 10 hours and 35 minutes.

= 10 hours * 60 minutes = 600 minutes + 35 minutes

= 635 minutes.

[Sokkorn]

Hi,

Try to add new field as I put in Bold

Rep:
LOAD Cliente as ClienteEJ, 
     Area as AreaEJ, 
     SumOfSum_Diferencia as  SumOfSum_DiferenciaEJ, 
     RE_Cal1 as RE_Cal1EJ, 
     SumOfCant_Persona as  SumOfCant_PersonaEJ, 
     RE_Cal2 as RE_Cal2EJ, 
     RE_Cal3 as RE_Cal3EJ,
     Date(Fecha) as FechaEJ,
     Year(Fecha) as AñoEJ,
     Month(Fecha) as MesEJ,
     Week(Fecha) as SemanaEJ,
     Day(Fecha) as DiaEJ,
     INTERVAL(RE_Cal1+RE_Cal2+RE_Cal3,'hh:mm') as NewField
FROM
(biff, embedded labels, table is Base$);

Regards,

Sokkorn Cheav