subtracting time

[uabb]

Hello

I created new column and i enter formula where i subtract column 1 from 2 and times it by 24 and i get numbers like:

10:10 AM - 8:00 AM = 2 but 7:14 - 2:24 PM = 7.1666667

It doesn't let me choose time as data type, if i do it results in error as well. And I can't select rounding. Presently the data type is "Any".

[v-anabat]

Hi, 

Based on the details provided, I created a sample dataset and below and created a calculated column.

I have changed the datatype of these fileds in Power query editor itself.

Check if this works for you or provide the sample dataset of your requirement.