Calculate time difference in expression

[Anonymous]

Hi guys,

I have 2 time variables and I want to calculate average difference between them in pivot table.

Please see below.

How can I get it?

Thanks,

[bdunphy]

as time can just be subtracted. just use avg(time2-time1).

this should calculate correctly in a pivot table

[#3]

Using the DateDiff () function we can know the number of days, months, years, hours, minutes and seconds between two given dates.

The format of the function is as follows:

DateDiff ("period", date1, date2)

Which period can be:

d (day)

m (month)

yyyy (year)

h (hours)

m (min)

s (seconds)

Date1 and date2 variables contain dates to subtract.

[preminqlik]

Interval(cOMEDATETIME-SUBMITDATETIME,'d HH:MM')

[#5]

Hi,

It seems, you need the difference between submit & come DateTime in min's. so, use the below expression:

=Interval(submitDateTime-comeDateTime,'mm')

[Anonymous]

Hi guys, thanks for your ideas.

It doesn't work,

I need to calculate time difference in pivot table by Months.

Please see the attached file.

I have 2 dimensions: surveyID, MYear,

the expression should be avg(time differece between comeDate Time and submitDateTime in minut)

Thanks again.

[christian77]

Hi, here they go some solutions.

month(Date1)-month(Date2)  --> Need to know years.

Set up a period by

autonumber(Year&Month)   as Period_id

                                   Year&Month               as Period

then count Periods.

(Date1-Date2) / 30   --> Aproximate.

count({$<Date={'>=Date1<=Date2'}>} distinct Year&Month)  --> Every month involved.

[christian77]

Hi:

also:

avg(aggr(nodistinct Date1-Date2, RespondentID)))

[preminqlik]

hi there,

find attachment

hope this helps you

Regards

Premhas

[Anonymous]

thanks, but it didn't work