Time Tag Pivot Tables - Mac Instructions

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


Article Details

Article ID:
Rating :