search

YCSRobotics / GrizzlyTime

Grizzly Robotics Logging Application
MIT License
6 stars 8 forks source link

[Enhancement] Log time in and time out, count total hours in google sheets #18

Open memtech3 opened 2 years ago

memtech3 commented 2 years ago

I think teams could benefit from grizzlytime logging time in and out in google sheets and from having google sheets do the math for total hours so that teams can round punch times, correct punch errors, and verify validity of time entries.

memtech3 commented 2 years ago

one way to do this =SUMIF(Sheet1!A:AX,A2,Sheet1!D:D)

Sheet1: image

Totals Tab: image

Daltz333 commented 2 years ago

Are you fine with only storing the previous/current day Login/Logout? I'm not sure how to easily store up to 365 days worth of login/logouts.

memtech3 commented 2 years ago

I would prefer it if each punch had the time in and out logged and if the calculations for hours were done in the google sheets so that we can make corrections and manually enter hours if needed.

memtech3 commented 2 years ago

A thought: if the user is not checked in (check the logged in column), you could go through the list of punches and look for the first entry that matches the student ID that does not have a check out time and drop the current time there

Daltz333 commented 2 years ago

Calculations for hours means there is manual sheet configuration necessary and does make the app less "plug and play", so I'm a bit hesitant on it. Ideally the user should need to do no additional setup besides allowing GrizzlyTime necessary permissions.

memtech3 commented 2 years ago

When grizzly time creates each row it can put the =diff (for time entries) and =sumif (for user entries) in the right column

Daltz333 commented 2 years ago

But then how do you log the individual day timein/timeout? You'd only be able to do one day at a time? I guess can I have a screenshot of an example of one week where the individual timein/timeout are logged?

memtech3 commented 2 years ago

Ah I forgot about that! This might work better imageThis is the Date Time format in google sheets. When you subtract or add those fields, you get a result in hours

Daltz333 commented 2 years ago

But then you'd have thousands of rows of data (~30 students over 120 days would be a ton of rows!)

memtech3 commented 2 years ago

Don't you currently log each day?

memtech3 commented 2 years ago

Are you free for a discord call? We may be able to work this out better over a higher bandwidth communication medium memtech3#8285

Daltz333 commented 2 years ago

I'm available on the FRC discord