The problem
Two people using the export describe the same clean-up job. Both notes come from the same public request page, read on 11 November 2026.
In the CSV export of the Time Tracked reporting view, the time fields are exported in text format ("3h 50m").
From the ClickUp feature request 'Time Format in Exports' (156 votes on 11 November 2026, posted 12 March 2019)
the time format coming out in CSV in milliseconds is of no use
Same source, a comment from 30 August 2024.
The ClickUp feature request 'Time Tracking Exports', posted 18 August 2020, showed 366 votes and no status label on 11 November 2026.
Free how-to: turn the durations into decimal hours
Spread the durations down column A, with the first value in A2. Put the formula in B2 and fill it down to the last row of your export.
Milliseconds to decimal hours
If the cell holds milliseconds as a whole number, divide by 3,600,000, the number of milliseconds in an hour. One hour is 3,600,000 milliseconds.
Divide the value: =A2/3600000
To show two decimal places, round the result: =ROUND(A2/3600000,2)
Text such as 2 h 15 m or 3h 50m to decimal hours
If the cell holds text such as 2 h 15 m or 3h 50m, use one formula. It copes with or without a space, and with only hours or only minutes. It reads the hours before the h, the minutes after it, and falls back to minutes alone when there is no h.
=ROUND(IFERROR(VALUE(LEFT(SUBSTITUTE(A2,"m",""),SEARCH("h",A2)-1))+IFERROR(VALUE(MID(SUBSTITUTE(A2,"m",""),SEARCH("h",A2)+1,3)),0)/60,VALUE(LEFT(SUBSTITUTE(A2,"m",""),SEARCH("m",A2)-1))/60),2)
Worked examples
| Duration in the export | Decimal hours |
|---|---|
| 2 h 15 m | 2.25 |
| 3h 50m | 3.83 |
| 45 m | 0.75 |
| 4 h | 4.00 |
Check the result against a few entries before you invoice.
The planned converter
The free formulas above do the conversion by hand. The offer below is a planned converter that would do it for you.
Our suggestion: turn the text or millisecond durations in your export into decimal hours for invoicing. Columns and notes are included only if your export has them. This converter is planned, not built, and may never be built. No payment is taken. Pressing only counts your interest.
It would read the CSV that ClickUp exports, in your own browser, using whichever of these columns your file has: duration, date, person, task, list. It cannot add notes or priority if your export does not include them.
Free options exist. Everhour and Coupler.io both list free plans on their pricing pages (read 11 November 2026; limits apply), and a spreadsheet can do the conversion by hand. A ClickUp user also describes an API workaround on the ClickUp feedback board; we have not checked whether it works or is free. We have not tested any of these options.
How this page is checked
Every statement of fact on this page comes from the two public request pages recorded on 11 November 2026 and listed in the problem section. A test fails the build if a banned word appears, if the button is not exactly the required wording, if a rival price appears, or if the page carries a form, an email field or an outside script. If a source changes or we find an error, we correct this page and record it here.