cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## HOUR/MINUTE values

Hello everyone, I have a question for you

I have to calculate the response time of a service. I achieve that by obtaining the difference of two fields of a table. (end of service time - service start time)

Response = Hours[endtime] – Hours[starttime]

The data is expressed in format (yy-MM-dd HH:mm:ss)  So the expresión returns the data also in the same format.

But I need this value expressed in hours. So I came up with this solution

T_hs = HOUR(Hours[Response])

T_min= MINUTE(Hours[Response])

T_sec= SECOND(Hours[Response])

T_Response = Hours[T_hs]+ Hours[T_min]/60+ Hours[T_sec]/3600

The problem is that I end up with a decimal number that, although it is correct, expresses the hours in a format that does not work for me.

For example the result is 2.5 but I need to see it as 2:30 (hours: minutes).

I think the way I resolved this is not compatible with the way I need the information to be shown, maybe I should start over and find a better solution.

Any suggestions?

I have a similar problem with another field that has a value in seconds

I need this in minutes ...

TRATmin = Services[trat]/60

again the result is for example 4:75 when I really need to see it as 4:45

I use two card visualizations, in one for SUM and the other for AVERAGE. I have tu came up with a solution that Works for this tipe of visualization.

sorry for my English. It is not my native tongue.

Bye!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

## Re: HOUR/MINUTE values

This is not an uncommon problem. There are lots of issues with duration essentially. See these articles:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Super User IV

## Re: HOUR/MINUTE values

This is not an uncommon problem. There are lots of issues with duration essentially. See these articles:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Top Solution Authors
Top Kudoed Authors