Time calculation in load statement or chart

[#1]

Hello experts

Help me evaluate

=Interval((Date#(EQM_AUSBS,'M/D/YYYY')+time(EQM_AUZTB,'hh:mm:ss'))-(Date#(EQM_AUSVN,'M/D/YYYY')+time(EQM_AUZTV,'hh:mm:ss')),'hh:mm')

in chart or in load statement.

Thanks,

Ashif Tadvi

[tresesco · Accepted solution]

Like attached?

Your dates and times are proper timestamps, so no need to force parsing them.

[#3]

Hi,

try this expression, =Interval((num(Date#(EQM_AUSBS,'M/D/YYYY')&' '&time(EQM_AUZTB,'hh:mm:ss')))-(num(Date#(EQM_AUSVN,'M/D/YYYY')&' '&time(EQM_AUSVN,'hh:mm:ss'))),'hh:mm')

And I guess you need to show it against one more dimension.

Regards,

Amay