Timestamp Subtract

[#1]

Hi

Below is the requirement

MAR                                                        ALT_TIME                                                                   ACT_TIME

XXXXXXXXXXXXXX                             2015-01-27T04:54:54.62Z                                              2015-01-27T07:43:10.49Z

How to find the difference in the Timestamp

Regards,

Senthil

[PrashantSangle]

Hi,

Use Interval()

like Interval( ACT_TIME- ALT_TIME,'hh:mm')

Regards

[swuehl · Accepted solution]

If you need to interprete the timestamps:

=interval(

(date#(subfield('2015-01-27T07:43:10.49Z','T',1),'YYYY-MM-DD')+time#(TextBetween('2015-01-27T07:43:10.49Z','T','Z'),'hh:mm:ss.ff'))

-

(date#(subfield('2015-01-27T04:54:54.62Z','T',1),'YYYY-MM-DD')+time#(TextBetween('2015-01-27T04:54:54.62Z','T','Z'),'hh:mm:ss.ff'))

,'hh:mm:ss.ff')

[PrashantSangle]

Hi,

You can also try

Time(num(ACT_TIME - ALT_TIME),'hh:mm')

Regards

[#5]

Thanks Mate