Daylight
All articles

Jira time tracking guides

Convert Jira Hours to Decimal Hours: Keep the Exact Minutes

By Daylight team ·

A Jira worklog can show 1h 20m on screen, but the export writes 1.33. Jira stores the duration in seconds, and a CSV reader needs decimal hours. This page shows the conversion and why the two-decimal value does not remove your minutes.

Where Jira keeps the duration

Jira stores each worklog as a duration in seconds (Jira Cloud REST API, issue worklogs). The 1h 20m you read is a formatted display. The seconds stay exact underneath.

Daylight accepts 1h 30m, 45m, 1.5, and 1:30 on its timesheet grid, and keeps each entry at its exact minute value (Log time in Daylight). The display shows H:MM or decimal depending on your format. Neither changes the stored duration.

Convert H:MM to decimal

To convert for a CSV, divide the minutes by 60. Then add them to the hours. 1h 20m is 1 plus 20 divided by 60, or 1.333 hours. 1h 40m is 1 plus 40 divided by 60, or 1.667 hours.

A conversion chart showing logged H:MM values, their exact minutes, the exact decimal, and Daylight's two-decimal CSV value for each one.

The export is a rounded display

Daylight's report CSV writes decimal hours to two decimals, as 1.33 for 1h 20m (Reports and approvals). The cost uses the exact underlying duration, not the rounded display value.

At US$100 per hour, 1h 20m costs 100 times 1.3333, or US$133.33. Using the two-decimal 1.33 gives US$133.00. The two values differ by cents, and the worklog keeps the exact minutes.

Check one day against its entries

Sofia logs three entries on BILL-200 on the same day. The report sums them in seconds, then writes the decimal total.

EntryDurationDecimal
Design the checkout1h 20m1.333
Review the QA notes45m0.75
Write the migration script2h 15m2.25
Day total4h 20m4.333

1h 20m plus 45m is 2h 5m. Adding 2h 15m gives 4h 20m, which is 260 minutes and 4.333 decimal hours. Daylight's CSV writes 4.33.

Keep the worklog to reconcile

Keep the original H:MM worklog. It is the source of truth for the minutes. Use it to reconcile against the report. Daylight does not change your minutes when it exports. It rounds only the display value.

The sample report shows the same decimal export with a reconciled total row.

This article uses Atlassian's REST API documentation and Daylight's help pages and source, reviewed on November 15, 2026. The person, issue, and hours are fictional. The article does not report a customer result.

Read the reports instructions to review decimal hours, costs, and the export format in one place.