yogi_Set Up A Time Sheet For Clock Punch In As Specified By User

                                          Google Spreadsheet   Post  #1012

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 05, 2013

post by user: Brandon Fishman said:(http://productforums.google.com/forum/?zx=pk24ifk32f07#!category-topic/docs/spreadsheets/6XDlK_b2-bg)
Trying to make a timeclock 

Hi I am trying to create a simple time clock.  I'd appreciate some help.

Please view my shared sheet at https://docs.google.com/spreadsheet/ccc?key=0AnkVRC1UPDUGdDRqMEdSdHNLaWlhUG12amRKN0o2Qmc&usp=sharing

In this sheet, I am able to do this with basic formula's in excel, but can't figure out how to do it in Google using a form.  I'd appreciate any help. Ultimate goal would be to get an end of day total of hours worked and an end of week. 

thanks,
Brandon

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

please note

this layout is very error prone -- because

every person filling the FORM must submit

the FORM 4 times at 1) Punch In,

2) Lunch, 3) Lunch In, 4) Punch Out

and in your layout requiring all 4 entries must be successive entries for the same person -- this is a serious limitation and will definitely cause problems 

in any event, following is a solution to the problem  with your layout depicted in your post

yogi_Create Hyperlinks for An Array Of Values For Search Field In Column C

                                          Google Spreadsheet   Post  #1003

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 01, 2013

post by user: Brandon Fishman said:(http://productforums.google.com/forum/?zx=o6rqlebp7ykw#!category-topic/docs/spreadsheets/CLUV5CkzX_g)
Looking to do an Array Formula using a Hyperlink?
My Public URL is https://docs.google.com/spreadsheet/ccc?key=0AnkVRC1UPDUGdGNnYUtOR1lyMHBtVWlDNmJ5eGl6NFE&usp=sharing

I am trying to do a Concatenate Hyperlink. 

This would be used in a form, so I assume it would need to be an array formula but I can't figure it out. 

If a Name is in A3 Take the fomula in A1, and concatenate B3 to the end and display the name, if no  name is present display N/A.
Column D is there just to show my attempt that is failing.  
--------------------------------------------------------------------------------------------------------------

following is a solution to a bit more generalized problem

yogi_Make Computations By Inserting Computed Columns Into A Form Responses Sheet

                                          Google Spreadsheet   Post  #1002

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 31, 2013

post by user: Brandon Fishman said:(http://productforums.google.com/forum/?zx=7oinkl81cee#!category-topic/docs/spreadsheets/UEBn0I5w5pM)
How to submit form, and keep formulas?
Hi I am trying to setup a form, that when it goes into my google spreadsheet formulas are applied to the data entered.  

You can see my spreadsheet at: https://docs.google.com/spreadsheet/ccc?key=0AnkVRC1UPDUGdFV4bU9fWnhaX0x3bmFuakZGMzlvN1E&usp=sharing

If you look at the Spreadsheet Columns A-D are populated when the form is submitted, then I want E to populate with NOW() to show the current time. 
In Column F I want a formula to subtract A and E to display How much time has lapsed since the form was submitted and the current time.  
In Column I I am using the formula =IF(AND(F2>2,H2="Open"),"Working",)
This is working fine if the data is entered into the spreadsheet, but when someone submits the form the fomula's are not applied to the new lines.  Any suggestions on how to get the formula's to apply to all form submissions?

Thanks,
Brandon
-----------------------------------------------------------------------------------------------
following is my proposed solution to the problem