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

[memtech3]

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]

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

Sheet1:

Totals Tab:

[Daltz333]

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]

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]

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]

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]

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

[Daltz333]

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]

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

[Daltz333]

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

[memtech3]

Don't you currently log each day?

[memtech3]

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]

I'm available on the FRC discord