aronwoost / google-calendar-hours Goto Github PK
View Code? Open in Web Editor NEWCalculates hours for selected calendar for selected range.
Home Page: http://google-calendar-hours.com/
License: MIT License
Calculates hours for selected calendar for selected range.
Home Page: http://google-calendar-hours.com/
License: MIT License
Even though the project seemed to be abandoned, I've really enjoyed it. I hope someday you will implement the converter to percentage. Meaning, the time calculated there will be transformed into percents for each calendar section there
The ajax call can not follow a 302 "moved temporarily". Use jsonp? Or v3 API maybe?
sends 4 requests to google but only uses data from last one :(
The daily calculation seems not accurate if the item spans two days or reach 00:00. If I have some items between 23:30-0:00 and 0:00-0:30 it seems doesn't calculate.
Hi!
The Week feature adds an extra day. For example, 03.06.2019 - 10.06.2019 (June 6 — June 10).
If the week starts on Monday (June 3), it ends on Sunday (June 9).
The downside is it will add extra hours for the following day (June 10).
It appears to simply add 7 to the start date rather than account for the first day and move 6 from there.
ö
First off, I love this tool! I work as a consultant, and this makes handling logging of hours and preparing monthly invoices a breeze, so thanks!
Just one teeny tiny request: The csv output date format DD.MM.YYYY HH:mm doesn't play well with google sheets, so I have to fiddle a bit after import. A change to YYYY-MM-DD HH:mm – either as default or as an option – would make things even smoother :)
Given:
When
Then
Example: set your system clock to 2019-11-10, go to week mode and set 'Week starts on' to 'Monday', then click 'RESET to this week' - it'll set the range as 11.11.2019 - 18.11.2019
, despite the current date (10.11.2019
) not being in that range.
Thank you so much for your project! As a private contractor, it is essencial on my day to day for calculating bills for clients.
Unfortunately, it has stooped working for me a few months ago. Whenever I try to access my calendar, it shows Error 503 and a link I can't copy / click.
Is there a solution? Did I do something wrong?
I've noticed recently some items on my google cal are not being calculated in my totals.
here is a link to a screencapture
https://dl.dropboxusercontent.com/u/3603296/googlehours-daily-bug.mov
Overnight events (or more specifically, events that cross from one time period to the next) are not counted.
For example, there's an event in my calendar that started on Saturday and ended on Sunday. That event is not counted by the Google Calendar Hours Calculator for either last week or this week. Same thing if I have it calculate daily or monthly events; anything that crosses from one day or month to the next doesn't show on either the day it starts or the day it ends.
google-calendar-hours/index.html
Line 22 in 522f113
This might be intentional, but the top text is saying Calender insted of Calendar.
I can no longer select certain dates in the custom field. So basically I can't really use this app
2 issues I've found recently.
When I try to run a range of days, I have to select the day before and the day after the actual days that I want. For example, if I want the 1st-15th of the month, I have to select the last day of the previous month and the 16th, in order to have the 1st and 15th included. If I select from the 1st to the 15th, I only get results for the 2nd to the 14th.
The export to csv used to give me the date and the correct times in my time zone (mountain time), but now the export shows the times 6 hours ahead of the actual times in the events and the formatting is messed up, there's the date, then a T, then the time with 3 zeros and a Z after so I have to reformat the entire cell in order to get what I want which is the date and the correct time.
I have some calendar events that have durations that don't end in clean, obvious numbers. Such as an exactly 13-minute-long event. I believe I have more than a few of them. Adding them all together seems to lead to some display issues.
Whatever the cause, there are some farcically precise floating-point values on display in the summary.
Rounding these down to two decimal places would work well.
Uncaught TypeError: Cannot call method 'toLowerCase' of undefined
b/c JS is minified, I can't give a more accurate error description
In Chrome [64.0.3282.167 (Official Build) (64-bit)] I'm going to the page and clicking "Connect to Google Calendar", but I'm getting the following error:
Error: redirect_uri_mismatch
The redirect URI in the request, https://google-calendar-hours.com/auth.html, does not match the ones authorized for the OAuth client. To update the authorized redirect URIs, visit: https://console.developers.google.com/apis/credentials/oauthclient/502172359025.apps.googleusercontent.com?project=502172359025
Going to the developer console page simply says "Failed to load". Note that this happens in Incognito mode too.
a calendar that has dates going back to around 2006 (til today) only shows dates for 2006-2008 no newer ones. any idea why this could be?
Use google uuid instead of BB cid.
Hi, thanks for such an useful tool, i wonder if you could give some tips on how i could have the app inside my VPS with Apache.
Best regards,
Hi,
I have a feature request that would make the application much more useful for me.
I want to check how many hours I worked one week, and when I do check with my work calendar, sometimes I have multiple parallell events making the total hours for the week go more than actually time spent.
Would be great if there was an option to count paralell activites only one time.
Eirik
This would make my weekly time reporting task even easier
How can i run it on my local browser instead of server ?
Please can you provide some more details ?
I would like to see something like landing page with more info about how it works
for end user.
On website
Or in README you can add image like this one.
add "money earned per hour" input field and a text field showing money*hours_in_month.
It might be useful, as I'm sure many people use this tool for counting how much money they earn every month.
Thanks
toFixed(2)
Currently the order of details is according to sum of time spent on particular entry. This is nice but because of working (and putting events) in different timezone, it may happen that some events will be shifted to different month when doing summary in specific timezone. Sorting details in chronological order would allow to easy check if something like that happened.
Hey guy! Love this app. Currently I use it by combining Outlook 365 and gmail. Basically Iopen Calendar ICS from Outlook on my GMAIL calendar and then your program can count the hours.
Problem is Google takes a really long time to refresh this Calendar. So wanted to see if possible to make this into an Outlook Calendar counter.
i have a recurring event in one of my calendars and i think it's only counted once.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.