Saturday, December 19, 2015

yogi_SetUp TimeSheet For Range of Dates And Employees From data In ClockInOut Sheet

Google Spreadsheet   Post  #1994
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-19-2015
post by  Johanna Celsia:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification&hl=en#!category-topic/docs/spreadsheets/OH8-4GHAjdU
Trouble with processing data from time clock in/clock out Form responses
i'm having trouble with creating a custom timesheet to calculate all employee worked hours based on a criteria of a date range (ie. pay period). i've tried to search and read threads regarding calculating hours from the whole list of timestamps, but i'd like to try to create a sheet that that grabs the employee names and clock in/out timestamps, calculates the hours worked, and display it as 'time sheet' so that hours worked sums are easier to obtain. here's what i have so far. it's not much, but i've been playing around with functions and formulas all day and i can't seem to get it to work at all. any help would be awesome.

------------------------------------------------------------------------------------