Calculate time difference

[narender123]

Hi all ,

I have to calculate the time differnce between two dates . Likes:

Column1                                   Column2

09-09-2014 13:28:46                   41891.576825799

Calculate time formate like hh:mm:ss

Both columns are date column .Column2 is in Num format of date.

Please suggest.

Thanks,

Narender

[narender123]

Thank you.

Please see my reply to Jagan Mohan ,i have one more question.

Narender

[narender123]

Thank you.

Please see my reply to Jagan Mohan ,i have one more question.

Narender

[settu_periasamy]

Hi,

Did you try the Average instead of Sum in the Expression Tab?

[Digvijay_Singh]

Try selecting Avg of rows in Expressions/Total Mode option.

[narender123]

Hi Settu,

I have tried but it is showing same result as total

[narender123]

Hi Digvijay,

I have tried but it is showing same result as total.

[Anonymous]

By using the interval function it is working

[settu_periasamy]

Can you post the sample data? or screen shot?

[jagan]

Hi,

The date difference is in different format when compare to numbers.  How you want the sum to display in terms of Hours or Days?

For Days:

Ceil(Num(Time2 - Time1) )

For Hours:

Ceil(Num(Time2 - Time1) * 24 )

Hope this helps you.

Regards,

jagan.

[PrashantSangle]

Hi,

As other people suggested Expression Tab -> Total Mode -> Average of rows must work.

Can you give provide screen shot of your chart after applying above said suggestion.

Regards