Good evening Programming experts,
I need some assistance with an excel document that holds my sales team's punch in time and punch out time.
My data looks as such
Column A have dates
Column B I have name and last name of employee
Column C Duration between each punch in and punch out.
Column D Log in
Column E Log out
I would like to have sheet 1 to have a drop down to choose desired date and then a drop down for employee name, once they choose this I want that employees information alone to appear with name , duration between log in and log out and log in and log out.
I have attached a excel sample if needed.
Bookmarks