Appaq Labs

How to see who didn't log time in Jira Cloud

For team leads, project managers and Jira admins · Updated November 2026

Jira stores time as worklogs on issues. That makes "how much was logged on this issue" easy and "who on my team logged nothing on Tuesday" surprisingly hard: searches in Jira return issues, and a person with no worklogs has no issue to find.

1. What JQL can do

JQL finds issues that someone logged time on in a period. In the issue search (Filters → Search work items, advanced mode):

worklogDate >= startOfWeek() AND worklogAuthor = "Anna Petrova"
worklogDate >= startOfWeek(-1w) AND worklogDate < startOfWeek() AND worklogAuthor in membersOf("dev-team")

If the first search returns nothing, Anna logged nothing this week. You have to run it once per person, though, and it still won't tell you how many hours she logged on each day or which days are short.

2. The CSV workaround

  1. Run a JQL search such as worklogDate >= startOfMonth(-1) AND worklogDate < startOfMonth().
  2. Export → Export Excel CSV (all fields). Each worklog appears in a Log Work column as comment;date;author;seconds.
  3. In a spreadsheet, split those columns, convert seconds to hours and build a pivot table: authors as rows, dates as columns.
  4. Compare each cell with the daily norm. Anyone missing from the pivot logged nothing at all.

It works, but it takes 15–30 minutes each time, exports only issues matching the search, and is easy to get wrong when a worklog was started on one date and the issue was updated on another.

3. Jira Automation

A scheduled rule can run a JQL search and email a list of issues. It can't easily compare each person's hours with a norm per day, so it's better for "please log your time" reminders to everyone than for finding the actual gaps.

4. A timesheet that shows the gaps

Team Timesheet & Missing Worklogs (our app) builds this view from the worklogs already in Jira — no timer, nothing to set up:

It's read-only and runs on Atlassian's own infrastructure, so worklogs never leave your Jira site. Free for up to 10 users. How it works →