Knowledgebase
Region IX Education Cooperative > Region 9 Support > Knowledgebase

Time Tag Pivot Tables - Mac Instructions

Solution

Reports to Calculate Employee’s Days Worked

  • In Time Tag go to reports and select the users you want to access data on.

    • type their names and select all you want

      • choose the date range you are interested in

        • ie:  all time • or this month your choice

      • Select details

        • choose by user by day

        • export to csv the results

  • Drop on excel or open excel and import data and choose the csv file you just exported

    • select the data you are working with:  A1 to bottom right of data

      • click once on A1 then scroll to bottom right of data and “shift click”

    • choose pivot table and make the following selections.

      • duration minutes - “drag” - put in summation / values box (bottom right)

      • date - put in Row labels

      • user - put in Report Filter

      • category - put in Report Filter

        • *** important - Leave Column Labels Blank

    • To calculate ½ days and full days based on 3.75 hr ½ work day & 7.5 hr full work day

      • Enter the following formula at the bottom of the first user column

      • =IF(B6>=450, 1, IF(B6>=225, 0.5, 0))

        • in this example: B6 is the first cell with time worked in it.

        • Select your employee and print the single sheet for them.

  • Conditional Formatting to make data “jump”

    • To highlight the entries below 450 minutes

      • Go to "conditional formatting" under Format

        • choose 2 color

          • min number 449.99

          • max number 450

            • choose colors or leave alone

 

 

  • Format the spreadsheet in any format you want

    • add any data you want to type beside or below

 

  • there you go

 

 
Was this article helpful? yes / no
Related articles Time Tag Pivot Tables - Windows PC Office 2013 Instructions
Article details
Article ID: 3
Category: Knowledgebase
Date added: 2016-04-11 16:21:58
Views: 64
Rating (Votes): Article rated 1.0/5.0 (1)

 
« Go back

 
Powered by Help Desk Software HESK, brought to you by SysAid