Time Formats in Time Between Statuses App

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

Open

Minutes

The usual format calculates the time in minutes.

Open

HoursMinutes

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

If the Post on Linkedin in the Cycle Time calculation has a value of 12622m, then it is 210h 22m in HoursMinutes format.

Hours:Minutes

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

If the Post on Linkedin in the Cycle Time calculation has a value of 12622m, then it is 210:22 in HoursMinutes 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 for a particular task Cycle time was equal 210h 22m, then in this format, this value will be equal to 8d 18h 22m.

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

To convert the time duration of 210h 22m into decimal days, you can use the following formula:

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

So, the time duration of 210h 22m is approximately 8.77 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 210h 22m to decimal hours, you can use the following formula:

Decimal Hours = Hours + (Minutes / 60)

Decimal Hours = 210 + (22 / 60)

Decimal Hours = 210 + 0.36666 (rounded to four decimal places)

Decimal Hours ≈ 210.38

So, 210 hours and 22 minutes equal 210.38 decimal hours.

Business DaysHoursMinutes

What a Business Day is is described in detail in the section Work Schedule.

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 133h 9m is approximately 5.55 decimal days.

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

5.55/0,33 ≈ 16.84

Business Decimal Weeks

In the Decimal Weeks section, we calculated that in the generally accepted concept of 1 week = 7 days, 1 decimal day equals 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

16.84 Business Decimal Days * 0.2 = 3.33 Business Decimal Weeks