Hi guys, I have been trying to solve a problem for a month that I have right now. All I look for is to crate database table in sheet1, most likely along with drop down button (creating from name manager and validate cell along with list and the name right?).
I have more than 200 data and I am going to get by choosing designated technician in first column, required date in 2ndand specific time frame(could be 12am-12pm or 12pm-12am) in third column and I wish for getting the calculation of result over the sheet.
The major trouble is to get the idea of choosing the perfect rule for it in order to make it differentiated the 12 hrs frame of time and to calculate the data through the sheet and I hope I can try COUNTIF. Could you please provide something regarding this?