Timesheet

Overview

In ManicTime tags are used to track work. Timesheet is a view optimized just for tags, which allows you to generate different work reports.
Lets look at how it works. For example lets say these are my tags for the week:

Date Tag Duration
Aug 18 Client 1, Project 1, Design
Note: Home page design for www.projectone.com
4h
Client 1, Project 1, Testing
Note: Testing server connection
4h
Aug 19 Client 1, Project 1, Testing
Note: Testing server connection
4h
Client 1, Project 2, Design
Note: Application UI design
4h
Aug 20 Client 1, Project 3, Meeting
Note: Discussing integration with their current environment
4h
Client 1, Project 2, Design
Note: Application UI design
4h
Aug 21 Client 1, Project 3, Meeting
Note: Discussing UI
8h
Aug 22 Client 1, Project 1, Testing
Note: Testing compatibility with their environment
8h

For the first report lets just set the date range and click Generate report. This is what I get:

From this view I can clearly see that I worked on Client 1, Project 1, Testing on Monday, Tuesday and Friday, a total of 16hrs.
You probably noticed that all I only worked for Client 1. Now lets say our boss asks us for a report showing just projects for Client 1, nothing else.

Group by

In ManicTime tags are separated by comma. So we could say that tag 'level 1, level 2, level 3' is three levels deep. In the sample data, second tags were always projects, so in the field Group by I can now choose Second level tags instead of All tags. This will produce the following output:

Grouping fields allow you to specify by what to group, before ManicTime starts adding up time.
You have an option to group by different fields. Given this tag:

Tag:"Tag 1, Tag 2, Tag 3, Tag 4"
Note:"Sample note" 
Start:"8/25/2011 10:00AM"
End:"8/25/2011 11:00AM"

following would be the output of different options:

  • All tags - Tag 1, Tag 2, Tag 3, Tag 4
  • First level tags - Tag 1
  • Second level tags - Tag 2
  • Third level tags - Tag 3
  • Fourth level tags - Tag 4
  • Note - Sample note
  • Day - 25
  • Month - 8
  • Year - 2011
  • Timeline - Beside local tags, Timesheet can also be used to generate reports for Autotags and server Tag timelines. This option is useful if you generate report from two or more timelines, where you need to see how much work came from one timeline and how much from the other.

Total by

By changing Total by field you are telling ManicTime that when it start adding time up, it should sum it by day, or by month...

Include notes

When include notes is checked, all the different notes will be appended to the end of the table, each in its own line. This is useful if for example you just want to see how much time you worked on a Project and all the notes you wrote during that time.

Select source

You can select which users are included in the report. By default tags from everyone will be included.

Rounding

Creating tags by dragging on the timelines produces tags which are accurate to a second. Some users like to manually enter tags which are always rounded to half an hour for example. What we like to suggest, is that you keep tags accurate to a second, then round them on export. This way it is much easier to enter tags and your reports will be as accurate as they can be.

To round values in the timesheet, check Enable rounding. There are two settings, the value you want to round to and how ManicTime performs the rounding:

  • Nearest - each value in the timesheet will be rounded to the nearest value
  • Top - each value will be rounded to top
  • Bottom - each value will be rounded to bottom
  • Keep same total - If the original sum for example is 154.56, ManicTime will try to manipulate the data so that the total will be around 155. Usually this has very similar results as Nearest option

Never round to zero option

Use this option if you always want to bill the minimum amount. Below you can see the difference if rounding is set to one hour.

Tag Rounding disabled Round to nearest Round to nearest with Never round to zero
Client 1 0.07h 0h 1h
Client 2 1.25h 1h 1h
Client 3 1.75h 2h 2h

Include unrounded option

When checked, each column will show two values, rounded and unrounded (in parenthesis). When exporting to Excel, rounded and unrounded values will be in two separate columns.

Saving timesheets

Usually we make the same reports every week/month and it would be a shame to set it up every time. So once you are satisfied with the report, save it. When you click on save, ManicTime doesn't save the report, just the settings on the left hand side used to generate it, so you can reuse it next week/month. To save the report, click on Save options next to Generate report.

You'll be asked to provide a name. You can also choose to save the date range with the report. If you do, next time you load the report Date range will also be applied.

To load a timesheet, click on the Load options and choose timesheet to load.

Scheduled timesheet email report

If you need to create timesheet report every month or week, you can create scheduled timesheet email report. To create it, first set all needed settings and generate a report you want to receive. Once you are satisfied with the report, click on "Create scheduled timesheet email".

On the "Create scheduled timesheet email" form you can choose some settings:

  • Timesheet options - choose for which date range you want the report
  • Recipients - who should receive it
  • Schedule email - when the report should be created and sent

You can click Send now to see how the report looks. Report will be added to email as attachment.

Filter timesheets

Filter works in the same way as on the Day view or Advanced search.
Let's say I want to filter by just Project 1. I can type "Project 1" into filter box and generate report again.

Similarly, if I want to include everything except Project 1 I can use -"Project 1".

Filtering on tags in specific place

We had a question if its possible to filter tags, which for example have tag "Pizza" in third place, so for example:

match - "Personal, Lunch, Pizza"

not a match - "Personal, Pizza"

It is possible with the use of regular expressions. Here is how to filter for Pizza on 3rd place:

#"^\[^,\]\*, \[^,\]\*, Pizza"    

There is extensive help about regular expressions on the web, you can read more about them here.

Here is how you would use it to filter on for tag on 1st place:

#"^Some tag in first place,"

To filter on tag in 2nd place:

#"^\[^,\]\*, Some tag in second place"

To filter on tag on 3rd place:

#"^\[^,\]\*, \[^,\]\*, Some tag in third place"

tag on 4th place:

#"^\[^,\]\*, \[^,\]\*, \[^,\]\*, Some tag in fourth place"

You are probably seeing the pattern by now.

There are two things to beware of:

  • There is always space after the comma, then comes the name of your tag
  • Casing is important, so there is a difference between Lunch and lunch

And you can use - to include everything except the match.

And when you are satisfied with the report, use the save button at the top to spare yourself the trouble of going through the gibberish above a month later.

Exporting data from timesheet

Once you generate the timesheet, you have three options to export the data:

  • Copy to clipboard
  • Export to Excel
  • Export to csv

Copy to clipboard

Use this option if you want to copy to Word or Excel. Click on Copy to clipboard, open Word or Excel and paste (Ctrl-V).

Export to csv

Export to csv file. You can use .csv file as an import in many applications.