Home > Back-end >  Google Sheets Formula that finds employee with most hours worked for a specific location and shift (
Google Sheets Formula that finds employee with most hours worked for a specific location and shift (

Time:04-21

In Google Sheets, I need to find out which employee works more than 50% of the hours for a given shift at a given location based on timecard data (Table in col G:J). In the attached google sheet I need a formula in Column C that returns the name of the matching employee useing Column A & B for criteria, then column D and E should auto calcuate.

enter image description here

  • Related