Noxqss38242
Board Regular
- Joined
- Sep 15, 2017
- Messages
- 223
- Office Version
- 2016
Can I pull total numbers with a formula?
On TAB2
Cell A has a terminal code, ie: MU
Cell B has tech initials, ie: WG1
Cell C has in date
Cell D has in time
Cell E has out date
Cell F has out time
Cell J has total time clocked for that job.
Problem is that the techs have multiple clocking in and out per day. Is there a formula that will pull individual total time for the specific day?
So, he had .4, .7, .3, and .1 for 1/2/20. Total is 1.5.
Tab1
I have the spreadsheet on Tab 1 with the techs initials and end date created that is tracking other information already. I'm wanting to insert a column, let's just say column G with the total found on Tab2 per initial, per day.
So I'm guessing a vlookup situation but somehow pulling the sum total for each tech on each day.
OR
Somehow just sum the total for each day, per tech in a separate column on Tab2, then vlookup only that column for Tab1 based off also the date? Oh the madness!!
On TAB2
Cell A has a terminal code, ie: MU
Cell B has tech initials, ie: WG1
Cell C has in date
Cell D has in time
Cell E has out date
Cell F has out time
Cell J has total time clocked for that job.
Problem is that the techs have multiple clocking in and out per day. Is there a formula that will pull individual total time for the specific day?
So, he had .4, .7, .3, and .1 for 1/2/20. Total is 1.5.
Tab1
I have the spreadsheet on Tab 1 with the techs initials and end date created that is tracking other information already. I'm wanting to insert a column, let's just say column G with the total found on Tab2 per initial, per day.
So I'm guessing a vlookup situation but somehow pulling the sum total for each tech on each day.
OR
Somehow just sum the total for each day, per tech in a separate column on Tab2, then vlookup only that column for Tab1 based off also the date? Oh the madness!!