Interval between time start and end

[marcohadiyanto]

Hi All,

i'm trying to get interval between time start and time end (StartTime) - (EndTime), my time format is 24 hours. when StartTime greater than EndTime, it's fine, but  if EndTime greater than StartTime, the interval function always doing the minimum interval.

ex 1:

StartTime : 10:00:00

EndTime : 12:00:00

interval : 2:00

---------------------------------> it's work perfect it's calculate between 10AM to 12 PM.

ex2:

StartTime : 10:00:00

EndTime : 02:00:00

interval 8:00

--------------------------------->it's Error because it's only calculate between 10AM to 2AM. the result i want is 16:00

what's expression to make this interval correctly?

regards,,

Marco

[marcohadiyanto]

hi,

i want to sum the interval of time that you solve before,

Start Time : Time#(num(Only({<STAGR={'MTBJOS'}>}SMEBTR)*100,'0000'),'hhmm')

End Time :Time#(num(Only({<STAGR={'MTBJOF'}>}SMEBTR)*100,'0000'),'hhmm')

i want to sum the value of interval between Starttime and Datetime.

Regards,

[CELAMBARASAN]

Hi,

     Have you tried with this

     Without the sum in the expression what result your getting?Why going for sum?Can you tell me a brief about that?

Celambarasan

[marcohadiyanto]

Hi,

the data something like this,

Month	Day	STAGR	SMEBTR
1	1	Start	1000
1	1	End	1200
1	2	Start	1200
1	2	End	1800
2	3	Start	1300
2	3	End	200
2	3	Start	1000
2	3	End	500

after i get the result interval time for each day, now i want to calculate total for 1 month.

Regards,

Marco

[CELAMBARASAN]

Hi,

     Try with this

       =Sum(aggr(Expression,Day,Month))

Celambarasan