Export Employee Hours from Your Teamup Calendar

Many employers or supervisors have employees log or schedule their hours with a shared Teamup calendar. At times, they may need to pull reports for use in their payroll system or other financial tracking.
As one Teamup user explained:
“I need to convert each employee sub-calendar to a spreadsheet which sums all the working hours of each employee, so we can send the total worked hours to the finance department.”
Teamup has built-in exporting options available to make this a simple task.

How to export reports from your calendar

 The calendar administrator can export the data from Teamup sub-calendars to a CSV file. To do so, go to Settings > Export Events. From the Export Format menu, choose Comma Separated Values (.csv). Then you can customize the export options.
Customize the export options.

Once you have the options set as you want, click the green Export button to download the CSV file. You can then import the data into Excel; make sure to check “My data has headers.” It will be a delimited file, with the fields delimited by commas.

To generate the report, you could sort by “Calendar Name,” using the start time and end time of each event to calculate the hours for each employee’s sub-calendar. You may need to insert a column for the calculated results.

Learn more: 

How to Change the Order of Event Fields

Teamup's event fields are like columns on Excel that represent structured categories of information. If there are many fields, it may be helpful to...
Jenny
0 sec read

How to Quickly Copy Events

Using ctrl-drag and drop to quickly copy an event to another sub-calendar in the Scheduler view or Timeline view. The right-click context menu of...
Jenny
0 sec read