Time difference between 'OFF' and the immediate next 'ON'.

[ccdyat]

Hi Friends,

I have attached the sample data along with this. I need help to find the Time difference between 'OFF' and the immediate next 'ON'. 

It will be more helpful,if the solution is with In-DB Tools.

Thanks & Regards,

Sreekanth

[ccdyat]

Thanks @OllieClarke

[ccdyat]

Hi Team,

Can someone help me with In-DB formula for the below.

DateTimeDiff([Field1], [Field2], "minutes")

Regards,

Sreekanth