Rhon Alvarez
Member
Hi Team,
Asking for your help with regards to the attached file wherein the corresponding Time In and Time out of each employee would reflect for the provided date based on the raw data from another sheet.
I tried using helper columns but i managed to do only the Time In portion.
kindly provide formula for the Time Out portion and should there be a much simpler formula than what i've done for the Time in portion, please do provide/edit as well.
Thank you in advance.
Asking for your help with regards to the attached file wherein the corresponding Time In and Time out of each employee would reflect for the provided date based on the raw data from another sheet.
I tried using helper columns but i managed to do only the Time In portion.
kindly provide formula for the Time Out portion and should there be a much simpler formula than what i've done for the Time in portion, please do provide/edit as well.
Thank you in advance.