Find total login hours

hi,

I am new to the forum so please excuse me if i am posting in the wrong thread. I have a worksheet where there are multiple login time for an agent and logout for the same. I want to find out the first login time and last logout time and calculate total login time for the agent. a sample worksheet is attached for reference. Please help me with a VBA so that this can be automated.

hi compumast, welcome to ExcelForum, VB option if I understood you right

Thank you so much brother, you saved my life. I am new to VBA and handling a new role. I shall require your help in future as well. Thanks for this and thanx in advance. God bless you