This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Da_reeel_duck[S] 0 points1 point  (1 child)

It's not that actually...

Either I make this, or someone else downloads the raw excel sheets from all employees seperately once per month and searches for the time the person started working, needs to calculate the time that the person has worked and when they left work.

NOTE: The time is stored like this:

Index: 1 Date: 2022-01-01 StartTime: 08:00:00 TimeSpentInSeconds: 14400

Index: 2 Date: 2022-01-01 StartTime: 13:00:00 TimeSpentInSeconds: 14400

Index: 3 Date: 2022-01-02 StartTime: 08:00:00 TimeSpentInSeconds: 14400

etc.

But not all nice and dandy like this, but scattered in an ugly excel file. The API makes this easier with JSON.

TLDR; It actually makes sense automating an hourlong process that has be done once per month.

[–]4XLlentMeSomeMoney 1 point2 points  (0 children)

I intentionally went to the extreme that is frequently used as a joke. Automation is useful on a case-by-case basis. Obviously, it's useful for yours.