Announcements
cancel
Showing results for
Did you mean:
Specialist

## Sum Time

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!

1 Solution

Accepted Solutions
Creator III

Hi

Thanks

rohit

3 Replies
Creator III

Hi

Thanks

rohit

Anonymous
Not applicable

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.

Master

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 NewFieldFROM(biff, embedded labels, table is Base\$);`

Regards,

Sokkorn Cheav

Community Browser