PUNCHCARD Download Get Punchcard $9

How to see how long you worked on a document on a Mac

· 6 min read

A Mac does not keep a stopwatch for each file, so no single field says “you spent nine hours on this.” What it does keep is a set of clues: when the file was created, when it last changed, which days it was opened, and every saved version with a time on it. Put those together and you can rebuild a fair estimate. Here is where each clue lives and how far to trust it.

Start with the dates in Finder

  1. Select the document in Finder.
  2. Press Command-I, or choose File, Get Info.
  3. Under General, read Created, Modified and Last opened.

Created to Modified is the span of the work, from the first day to the most recent change. Treat it as the outer limit, not the answer. A report created on Monday and last modified on Friday took at most five days and possibly forty minutes.

Two cautions apply. A file that came from Save As, an export, a download or an email attachment can carry a Created date that is later than the day you really began. And Modified moves on any save, including the one where you fixed a comma a month later.

To compare several files at once, open the folder in list view, press Command-J, and tick Date Created, Date Modified and Date Last Opened.

Ask Spotlight which days you opened it

Finder shows only the last time a file was opened. Spotlight’s metadata holds a little more. Open Terminal, type the following with a space at the end, drag the document from Finder into the Terminal window to fill in its path, and press Return:

mdls -name kMDItemUseCount -name kMDItemUsedDates

The output looks something like this:

kMDItemUseCount  = 14
kMDItemUsedDates = (
    "2026-09-28 04:00:00 +0000",
    "2026-09-29 04:00:00 +0000",
    "2026-10-01 04:00:00 +0000"
)

kMDItemUseCount is how many times the file has been opened. kMDItemUsedDates lists the days it was opened, one entry per day. The dates are printed in UTC (the +0000 at the end), so adjust for your time zone before reading them.

This is the most useful clue on the list, because it turns “sometime that week” into “on three of those five days.” It has limits. It lists days, not hours. How far back it reaches varies. And if it prints (null), Spotlight has no record, which can happen for files on external or network disks.

Read the version history

Apps built on the macOS document system keep earlier versions of a file as you work. TextEdit, Pages, Numbers, Keynote and Preview all do.

  1. Open the document.
  2. Choose File, Revert To, Browse All Versions.
  3. Step back through the stack on the right. Each version shows the date and time it was saved.

Versions are stored when you save and at intervals while you work, so they arrive in clusters. A cluster on Tuesday morning from 9:10 to 11:40 is a working session of about two and a half hours. Write down the first and last time of each cluster, add them up, and you have the closest thing to a session log the file itself can give you. Click Done to leave without changing anything.

The limits here are practical. Versions do not always travel with the file, so a copy that was emailed, exported or moved to another disk may start with none. Apps that do not use this system have no Browse All Versions item at all. Documents edited in a browser usually have their own version history in the editor’s File menu, and the same reading applies: timestamps grouped into sessions.

Check whether the file kept its own count

Some word processors store a total editing time inside the document, shown in a properties or statistics panel. It is worth a look, and worth reading skeptically. That figure generally counts time the document was open in the app, not time you were typing, so a file left open over lunch gets credit for lunch. A document that began life as a copy of an older one may also inherit the older file’s count.

What none of these clues can tell you

Every method above measures the file, and a document is more than its file. The hour you spent reading sources in a browser, the call where the outline changed, the reference PDF you had open beside it: none of that is written into the document’s dates.

The file also cannot tell open from in front. A draft can sit open behind your mail app all afternoon, picking up a saved version each time you glance back and change a word. The versions will look like a four-hour session. It was twenty minutes.

So treat the file’s own evidence as an outline: which days, and roughly which hours. The missing piece is what was really in front of you during those hours.

Fill the gap with a record of your day

Punchcard keeps that piece. It sits in the menu bar and notices which app is in front as you work. At the closing time you set, it prints a paper receipt of the day: the top five apps with the time on each, the rest as MISC, and a day total.

One thing first, plainly: Punchcard never records document names or window titles, so it cannot tell you how long a particular document took. It has no per-document or per-project tracking. What it can do is supply the hours for the days the file gives you:

  1. Use mdls or the version history to list the days you worked on the document.
  2. Find those days in your record and read the time for the app you wrote it in.
  3. If you used that app for nothing else on those days, the sum is your figure. If you worked on other documents too, the sum is a ceiling.

For a closer fit, use the CSV export. It has one row per session with a start, an end, the app and the seconds. Line those session times up against the version clusters from the document, and you can see which stretches in the app belonged to this file.

Tracking is free and does not expire, the first two receipts are free, and the CSV export works without a license. Printing receipts after the first two needs the license, $9 once.

For more on why open time and working time differ, see The difference between time spent and time worked. If the document is a recurring one, How long does it take to write a client report? shows how to measure the next one from the start.

Questions

Does Finder show how long a file was open?

No. Finder shows dates: created, modified and last opened. None of them is a duration.

Why is the Created date later than when I started?

The file is probably a later copy. Save As, exporting to another format and downloading an attachment all make a new file with a new Created date. The original draft, if you still have it, holds the earlier one.

Will Punchcard show time per document?

No, by design. It records app names, and site names if you switch on itemized browsing. Document names and window titles are never recorded, which is also why it needs no Accessibility or Screen Recording permission.