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
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/
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 view my shared sheet at https://docs.google.com/
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
No comments:
Post a Comment