Timesheet log - ENTER

Meant to be used in conjunction with IFTTT recipe: Timesheet log - EXIT (both recipes log to the same spreadsheet). In your target spreadsheet, create labels in Row 1 & format each corresponding column: A:blank, B:blank, C:DAY (format "day" ex:"monday"), D:DATE (format date ex:"06/30/14"), E:TIME (format time ex:"hh:mm"), F:LUNCH (format duration ex:"elapsed hours:elapsed minutes"), G:HOURS (format duration ex:"elapsed hours:elapsed minutes"), F:=SUM(G:G) (format duration ex:"elapsed hours:elapsed minutes") Log deduct a one-hour lunch by default. Manually adjust if different.

by vallynn

Learn more

270 Users Enabled This Applet 270
works with
  • Location

Applet version ID 183174