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
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.
------------------------------------------------------------------------------------
No comments:
Post a Comment