How to sum and calculate time?

[#1]

Hi all, I have this data, and would like to sum the time worked. P_TYPE = 1 is for when You sign in, and P_TYPE = 2 is for signing out for breaks or end of day.  so my question is hos to do this?

Thanks in advance!

[its_anandrjs]

Hi,

It seems ok also when you create a resident table as (PLOCKARE_TID) did you try to drop the earlier table PLOCKARE_TIDSTAMPLINGAR at the end of the load script

Drop Table PLOCKARE_TIDSTAMPLINGAR;

Regards

Anand

[#3]

Hi,

I have dropped the earlier table now, but still not getting the desired effect.

I have made a minor change in the if statement. but its not calculating the time right?