Convert Jira's time notation (1w 2d 3h 30m) to hours, decimal days, or minutes — and back. Paste a full column of values to convert in bulk.
Paste one Jira time value per line into the input box and click Convert. You can paste directly from a Jira column, spreadsheet cell, or anywhere else — the converter handles it line by line and outputs a matching list you can paste straight back in.
The Hours per day and Days per week settings should match your Jira project configuration. The defaults (8h/day, 5d/week) are Jira's own defaults. If your team uses 7.5h days, change it once and all conversions update.
For bulk conversion, paste an entire spreadsheet column of Jira values. Each line is converted independently and the output preserves the same line order, so you can paste results back into a spreadsheet without realigning.
On the Hours → Jira tab, use the Input format chips to tell the converter what unit your numbers are in — hours, raw minutes, or decimal days. This is useful when copying from timesheets or spreadsheets that use different units.
| Unit | Meaning | Default value | Example |
|---|---|---|---|
| w | Weeks | 5 days | 2w = 80h |
| d | Days | 8 hours | 3d = 24h |
| h | Hours | 60 minutes | 4h = 4h |
| m | Minutes | — | 30m = 0.5h |
Jira's time tracking uses weeks, days, hours, and minutes rather than decimal hours because it maps to how people think about project schedules. A sprint is measured in days and weeks, not 37.5-hour blocks. The downside is that it's not directly comparable to decimal hours used in spreadsheets, timesheets, or other tools — which is what this converter is for.
Yes — use the Hours per day setting at the top of the page. In Jira, this is configured per-project under Project Settings → Time Tracking. Common values are 8h (default), 7.5h, or 7h depending on your organisation's working day.
Yes. 1w2d3h30m, 1w 2d 3h 30m, and 1w 2d are all handled identically. Units can be upper or lower case.
In Jira or your spreadsheet, select the time-logged column and copy it. Paste directly into the input box — each row lands on its own line. Click Convert and the output matches the same row order, ready to paste back.
Decimal values are supported: 1.5d is treated as 12 hours (at 8h/day default). Jira itself doesn't always display decimal units, but this converter handles them correctly on input.