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: 

Wrap Text in Table View to See Full Titles and Descriptions

Choose the Wrap content option in Table view to easily see full text of titles, events, and other fields. Adjust, hide, or show columns...
Annie
0 sec read

The Time Zone of Your Calendar Events

Wondering if your calendar events are in the right time zone? Worried about handling daylight savings time? Here's what you need to know about...
Annie
0 sec read

Scroll Through Date Picker with Mouse or Track Pad

How to do faster, easier date selection in your Teamup calendar -- scroll through the date picker with your mouse wheel or track pad.
Annie
0 sec read