Customizing Time Format for Time in Status Reports

The Format option lets you select the time format of status duration:

• Minutes

• HoursMinutes

• Hours:Minutes

• DaysHoursMinutes

• Decimal Weeks

• Decimal Hours

• Decimal Days

• Business Decimal Weeks

• Business Decimal Days

• Business DaysHoursMinutes

Let's look at different examples of calculating and displaying these formats.

Minutes

The usual format calculates the time in minutes.

HoursMinutes

A format is calculated and presented in the form 0h 0m.

If the Use cases task in the Cycle Time calculation has a value of 759 minutes, then it is 12h 39m in HoursMinutes format.

Hours:Minutes

The same as in the previous case, but without the letter designations following the numbers - 00:00.

If the Use cases task in the Cycle Time calculation has a value of 759 minutes, then it is 12:39 in Hours:Minutes format.

DaysHoursMinutes

In this case, all values are calculated and presented as 0d 0h 0m.
That is, it is known that there are 24 hours in a day, and if a particular task was in To do status for 30 hours and 32 minutes, then in this format, this value will be equal to 1d 6h 32m.

Decimal Weeks

Let's recall what fractions are to understand how this and other decimal formats work.

How To Calculate Days To Weeks:

To convert days to weeks, multiply your days by 0.1428571429. The formula would look like this:

Y_week = X_day * 0.1428571429

Using this simple example, we understand that if a week with 7 days is conditionally taken as 1, then the share of 1 day in a week is approximately 0.14.

Days To Weeks Conversion Table

Decimal Days

Decimal days refer to a time measurement system where a day is divided into decimals instead of the more conventional hours, minutes, and seconds.

To convert the time duration of 30 hours and 32 minutes into decimal days, you can use the following formula:

Let's apply this formula to the given time duration:

So, the time duration of 30 hours 32 minutes is approximately 1.2722 decimal days.

Decimal Hours

Decimal hours express time in a decimal format rather than the traditional hours, minutes, and seconds format. In this system, a day is divided into 24 hours, just like in the traditional system. However, each hour is divided into 100 decimal minutes, and each decimal minute is divided into 100 decimal seconds.

For example, in decimal hours:

1 hour is equal to 1.00

30 minutes is equal to 0.50 (half of an hour)

15 minutes is equal to 0.25 (a quarter of an hour)

45 minutes is equal to 0.75 (three-quarters of an hour)

This format is sometimes used in business and timekeeping for simplicity in calculations. It allows for easier addition and subtraction of time values, especially when dealing with fractions of an hour.

To convert 30 hours and 32 minutes to decimal hours, you can use the following formula:

Decimal Hours = Hours + (Minutes / 60)

For 30 hours and 32 minutes:

Decimal Hours = 30 + (32 / 60)

Decimal Hours = 30 + 0.5333 (rounded to four decimal places)

Decimal Hours ≈ 30.5333

So, 30 hours and 32 minutes equal 30.54 decimal hours.

Business DaysHoursMinutes

What a Business Day is is described in detail in the section Calendar Configuration.

For example, you have a work calendar configured like this:

That is if one regular calendar day is 24 hours. And according to this working calendar, one business day equals 8 hours.

Business Decimal Days

If your business working day is 8 hours, you can represent the business day in decimal form by dividing the number of hours worked by the total number of hours in a day (24 hours). In this case:

Substituting the values:

So, in this case, your business decimal day would be approximately 0.33, representing one-third of a day.

In the Decimal Days section, we considered the case of calculation:

The time duration of 30 hours 32 minutes is approximately 1.2722 decimal days.

These same 1.2722 decimal days in the Business Decimal Day format will be equal to

1.2722/0,33 ≈ 3.8

Business Decimal Weeks

In the Decimal Weeks section, we calculated that in the generally accepted concept of 1 week = 7 days, 1 decimal day is equal to 0.14.

If the working week according to the working calendar is 5 days, then 1 day is conventional:

1 (working week) / 5 (number of working days) = 0.2

512.83 Business Decimal Days * 0.2 = 102.57 Business Decimal Weeks

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net

Haven't used this add-on yet? Try it now!