This is a tool to convert an exported calender (.ics-file) into a table-formatted data grid, while calculating the hours you worked. I made it because I use iCal / BusyCal for keeping track of worked hours but these apps do not calculate those hours for you.
When you start the app, you'll see this screen:
You can load an .ics-file by dragging and dropping it onto the grid or by choosing Open... from the File-menu. When you load a file, the following tags get processed: DTSTART, DTEND, SUMMARY, LOCATION and DESCRIPTION. The start and end-times are split into two columns and the hours are calculated. Hours are rounded on whole and half hours.
Note: the tool does currently not honor the RRULE component.
You can broaden or narrow the display of the contents of the .ics-file by selecting from-to dates at the top of the screen.
You can hide or show columns by (de-)selecting the respective checkboxes and you can set the decimal point for half hours via the small pop-up menu. The file's contents are automatically reprocessed after each change in settings. After playing around, click inside the grid, select all contents via CMD-A and copy them via CMD-C.
Then paste into an invoice or a spreadsheet. That's it.
|for Mac OS X (Intel)||For Linux (GTK 2+)||for Windows|
v1 - 2011: Initial release
v2 - 2013: Fixes reading of Apple Calendar files.
v2.1 - 2013: Correctly reads event-data and multi-line descriptions
v2.2 - 2014: Repaired crash when no DTEND: present in calendar event.
v2.3 - 2015: Corrected DTEND for All-Day Events.
v2.4 - 2015: Corrected multi-line SUMMARY.
v2.5 - 2016:
- Sheet windows instead of modals,
- Link to new webpage,
- Better display of bigger text on Windows,
- 'Line No.' column now has a line number,
- ’Start at’ and 'End at' columns now also include the date in ISO format for better sorting.