Skip to content
CueCapture

Time Logs Database

CueCapture’s time tracking feature can log sessions to a dedicated Notion database. This lets you track billable hours, analyze where your time goes, and keep records in Notion.

How It Works

Section titled “How It Works”

When you track time in CueCapture:

  1. Start a timer on any task
  2. Work on the task
  3. Stop the timer
  4. CueCapture creates a time log entry in Notion

Each entry records:

  • Which task you worked on
  • When you started and stopped
  • Total duration
  • Optional notes

Prerequisites

Section titled “Prerequisites”
  • CueCapture connected to your Tasks database
  • Time Tracking feature enabled in CueCapture settings

Database Setup

Section titled “Database Setup”

  1. Create a Time Logs Database

    In Notion, create a new database with these properties:

    PropertyTypeRequired
    TitleTitle✅ Auto-generated name
    TaskRelation✅ Links to Tasks database
    Start TimeDate✅ With time enabled
    End TimeDate✅ With time enabled
    DurationNumber✅ Minutes (calculated)
    NotesTextOptional

  2. Configure Date Properties

    For Start Time and End Time:

    • Enable “Include time” in the property settings
    • This lets CueCapture record precise timestamps

  3. Link to Tasks Database

    Add a relation property:

    • Type: Relation
    • Select your Tasks database
    • This links each time log to a specific task

  4. Share with Integration

    • Click ”…” → “Connections”
    • Add your CueCapture integration

  5. Connect in CueCapture

    Open Settings → Notion Databases → Time Logs:

    • Paste your time logs database URL
    • Map each property

Property Mapping

Section titled “Property Mapping”

Required Mappings

Section titled “Required Mappings”
CueCapture FieldNotion PropertyDescription
TitleTitle propertyAuto-generated: “Task Name - Date”
TaskRelationLink to the task worked on
Start TimeDate with timeWhen timer started
DurationNumberMinutes spent

Optional Mappings

Section titled “Optional Mappings”
CueCapture FieldNotion PropertyDescription
End TimeDate with timeWhen timer stopped
NotesText/Rich textSession notes
ProjectRelationDirect project link (auto-filled from task)

Duration Formats

Section titled “Duration Formats”

CueCapture stores duration in minutes by default. You can change the display in Notion:

Minutes (Default)

Section titled “Minutes (Default)”
  • Stores: 45
  • Display: “45 min”
  • Best for: Short tasks, precision

Hours (Decimal)

Section titled “Hours (Decimal)”
  • Stores: 0.75
  • Display: “0.75 hrs”
  • Best for: Billing, timesheets

Configure in CueCapture

Section titled “Configure in CueCapture”

Settings → Time Tracking → Duration Format

Automatic Features

Section titled “Automatic Features”

Auto-Generated Titles

Section titled “Auto-Generated Titles”

Time logs are automatically titled:

"Write documentation - Dec 5, 2024"

Task Relation

Section titled “Task Relation”

CueCapture automatically links the time log to the task you were tracking.

Duration Calculation

Section titled “Duration Calculation”

If you have a formula property, CueCapture can auto-calculate:

// Notion formula for duration (in minutes)
dateBetween(prop("End Time"), prop("Start Time"), "minutes")

Project Linking

Section titled “Project Linking”

If your tasks have projects, time logs can automatically inherit the project relation.

Viewing Time Data

Section titled “Viewing Time Data”

In Notion

Section titled “In Notion”

Use Notion’s database views to analyze time:

By Task (Grouped)

  • Group by: Task relation
  • Sum: Duration
  • See total time per task

By Date (Timeline)

  • View: Timeline
  • Date property: Start Time
  • Visualize work sessions

By Project (Chart)

  • Group by: Project
  • Sum: Duration
  • See time allocation

In CueCapture

Section titled “In CueCapture”
  • Task details show total time tracked
  • Project view shows aggregate time
  • Today’s summary shows daily totals

Manual Time Entry

Section titled “Manual Time Entry”

You can also add time entries manually:

  1. Select a task
  2. Click the time tracking icon
  3. Select “Add Manual Entry”
  4. Enter start time, duration, and notes
  5. Entry syncs to Notion

Tips

Section titled “Tips”

Billable Hours

Section titled “Billable Hours”

Add a “Billable” checkbox property to mark entries for invoicing.

Hourly Rate

Section titled “Hourly Rate”

Add a formula to calculate earnings:

prop("Duration") / 60 * prop("Hourly Rate")

Weekly Totals

Section titled “Weekly Totals”

Create a Notion database view that:

  • Filters to current week
  • Sums duration by project
  • Perfect for timesheets

Pomodoro Technique

Section titled “Pomodoro Technique”

Use CueCapture’s timer with 25-minute intervals:

  • Start timer
  • Work for 25 minutes
  • Timer auto-stops (configurable)
  • Take a break
  • Each session logged separately

Troubleshooting

Section titled “Troubleshooting”

Time Logs Not Appearing

Section titled “Time Logs Not Appearing”
  1. Check database is shared with integration
  2. Verify property mappings in CueCapture
  3. Ensure Start Time has “Include time” enabled
  4. Check CueCapture logs for sync errors

Wrong Duration

Section titled “Wrong Duration”
  • Verify Duration property is type “Number”
  • Check the format (minutes vs hours)
  • Ensure no formula is overriding the value

Task Not Linking

Section titled “Task Not Linking”
  • Verify the relation property points to correct database
  • Check that the task exists in Notion
  • Try re-mapping the relation property

Timezone Issues

Section titled “Timezone Issues”
  • CueCapture uses your local timezone
  • Notion may display in different timezone
  • Check Notion’s timezone settings if times look wrong

Next Steps

Section titled “Next Steps”