cppcooper / time-tracker Goto Github PK

A submittable timesheet would calculate the hours for each day. Then calculate the total, rounded to the nearest quarter hour (or lowest? gotta check what the most common practice is here). Then calculate the gross pay.

This timesheet would require headers for columns.

Fields:

• time sheet:
  • day (of the week)
  • date
  • time in (multiple, as needed)
  • time out (multiple, as needed)
  • work hours
  • overtime hours
  • sick hours
  • holiday hours
  • vacation hours
• pay period:
  • work hours total
  • overtime hours total
  • sick hours total
  • holiday hours total
  • vacation hours
  • rate
  • sub-total
  • total

When kept running into a new day the timestamp is appended to the last line of the file, regardless of whether the date matches the current date or not.
Displayed:

                  [CLOCKED IN]
                  [2022-05-12]

File:

2022-05-11,08:05:43,17:19:00,07:44:54

When clocking in on an entirely new day, whilst not "clocked in" midnight timestamps are inserted erroneously.

2022-05-06,08:10:00,17:00:04,23:59:59
2022-05-10,00:00:00,08:24:25

Quickbooks provides an API https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/timeactivity