Saturday, December 30, 2017

yogi_Rearrange Start And End Times From DataBase Type Table Into Same Row

Google Spreadsheet   Post  #2334

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-30-2017
Start/end time questions: move to same row for calculations?
I have begun a timesheet where our school maintenance staff will use a form to enter their daily start/end times.

The start time is on one row in Form Responses 1; the end time is on another.

I (think I) need the start and end data to be on the same row for calculating total hours worked, etc.

My question is how can I group each employee's start and end time entries so that they are in a single row?

Please see sample sheet.

I thank you for your help!