Feature Release: Export Resource Utilization in Hours & Minutes

The Problem: Decimal Exports Caused Confusion

Admins rely on Resource Utilization reports to track the exact time each team member spends on projects. Previously, while Orangescrum displayed time in hours and minutes in the app (e.g., 2 hrs 45 mins), exported reports automatically converted the time into decimal format (e.g., 2.75 hrs).

This caused frustration: admins had to manually convert decimal hours back into hours and minutes to understand the actual time spent, which was time-consuming and prone to errors.

Real-World Example

Calculation in Decimal:

User Name	Project A	Project B	Project C
Alice Johnson	12.5	8.25	6.75
Bob Smith	10.0	7.5	5.25
Carol Williams	14.0	9.5	8.25
David Brown	11.25	8.0	7.5
Emily Davis	13.5	10.0	9.25
Frank Wilson	9.75	7.25	6.5
Grace Thompson	12.0	8.75	7.0
Henry Martinez	15.25	11.0	10.5

Total Hours Spent by All Users (Decimal): 229.5 hours

Although mathematically correct, this created confusion for managers who preferred to see time in hours and minutes, especially when tracking productivity or reporting to clients.

The Solution: Choose Your Export Format

Orangescrum now provides two export options for Resource Utilization reports:

1. Clock Wise Format

• Exports time in hours and minutes exactly as shown in the app.
• Example: 1 hr 30 mins, 2 hr 15 mins, etc.
• Makes reports easier to read and measure for managers and stakeholders.

2. Decimal Format

• Exports time in decimal values (e.g., 1.5 hrs, 2.25 hrs).
• Ideal for finance, payroll, or systems requiring decimal calculations.
• Now admins can select the format that fits their workflow, reducing errors and saving time.

Calculation in hrs and mins:

User Name	Project A	Project B	Project C
Alice Johnson	12hrs 30min	8 hrs 15 mins	6 hrs 45 mins
Bob Smith	10 hrs 0 mins	7 hrs 30 mins	5 hrs 15 mins
Carol Williams	14 hrs 0 mins	9 hrs 30 mins	8 hrs 15 mins
David Brown	11 hrs 15 mins	8 hrs 0 mins	7 hrs 30 mins
Emily Davis	13 hrs 30 mins	10 hrs 0 mins	9 hrs 15 mins
Frank Wilson	9 hrs 45 mins	7 hrs 15 mins	6 hrs 30 mins
Grace Thompson	12 hrs 0 mins	8 hrs 45 mins	7 hrs 0 mins
Henry Martinez	15 hrs 15 mins	11 hrs 0 mins	10 hrs 30 mins

Total Hours Spent by All Users (Decimal): 229hrs 30 mins

Benefits

Clarity & Accuracy – With the new Clock Wise export, the time displayed in the exported file now matches exactly what you see in the app. This eliminates confusion caused by decimals and ensures that project hours are correctly represented, giving admins confidence in their reporting.

Flexibility – Different teams have different needs. Finance teams may prefer decimal values for precise calculations, while managers and stakeholders may find hours and minutes easier to interpret. Now, admins can choose the format that works best for their workflow without any extra effort.

Time-Saving – Previously, admins had to manually convert decimal hours back into hours and minutes, especially when calculating totals for multiple projects or team members. The Clock Wise option removes this extra step, allowing users to generate accurate reports instantly.

Better Reporting & Communication – Reports in hours and minutes are easy to read and share. Whether it’s for internal review, client reporting, or team meetings, the exported files are now intuitive and clear, reducing errors and saving time in explanations.

How to Access the Export in Clock Option?

• Step-1: Log-in Orangescrum and select your Project
• Step-2: Navigate to the left-side menu and click on Resource Utilization

• Step-3: Now you can view the individual as well as cumulative time spent by each user. Now hover over to the top left and click on Export to CSV.
• Step-4: While exporting choose the option Clock view to get the excel file in clock (hh:mm) format

Pro Tip

Keep in mind that time in hours and minutes is calculated based on 60 minutes per hour, whereas decimal values are calculated based on 100.

This difference can create slight discrepancies when manually converting decimals back to hours and minutes. To ensure accurate reporting, we recommend always referring to the time values displayed in the Orangescrum application in hr:mm format when exporting resource utilization data.

Real-World Use Case

A project manager needs to send weekly time reports to stakeholders.

• Previously, exported reports were in decimals, requiring extra work to convert totals into hours and minutes for clarity.
• With the new Clock Wise export, the report now comes in hours and minutes, making it instantly understandable and easier to measure.

Finance teams can still use the decimal option for precise calculations, while managers can view time intuitively — everyone gets what they need.

Final Takeaway

With this update, Orangescrum makes resource utilization reports simpler, more accurate, and flexible. Whether you prefer hours & minutes or decimal hours, you now have the power to export your data your way.

Head over to Resource Utilization and try the new export options today—it’s reporting made easy.