I am Pulling time sheet work detail data every 5 minutes inserting into my master table , previously I was doing differences in minutes if I insert , meaning if an employee sends 50 minutes on 5/11 and then changes to 30 mins on 5/11 I would show 50 mins on 5/11 and -20 on 5/11,this works fine but does not work perfect if date worked changes,
so when I have any differences or changes in minutes I would like for it to behave this way. if an employee sends 60 mins on 5/11 and then changes to 40 mins on 5/11, I would like to see these record in my table
5/11 -60 mins
5/11 40 mins.
I would like assistance and just a general of how I can do this. Thank you