VBA for calculating hours

[sheen888]

Excel noob here, I am on macos with excel 365. I have a ticketing system that I want to track the remaining hours each person has on the ticket. Is there a way to create something that can calculate the different? I download the worksheets every morning and compare the hours like this

Ticket	assignee	summary	remaining hours
1122​	user1	test1	4​
1123​	user2	test2	4​
1124​	user3	test3	4​
1125​	user4	test4	4​

then the next day, I want to see if the assignee made any changes to the tickets

Ticket	assignee	summary	remaining hours	Time Spent
1122​	user1	test1	1​	3​
1123​	user2	test2	1​	3​
1124​	user3	test3	3​	1​
1125​	user4	test4	4​	0​
1136​	user1	test5	5​	0​

how do I achieve this?

 

[PeteWright]

Could you please tell me what data you get, what data is entered by user and what data you need?

Viewing your tables I can not distinguish that.