Forum Discussion

uabb's avatar
uabb
Frequent Visitor
7 years ago

subtracting time

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".

 

 

1 Reply

  • v-anabat's avatar
    v-anabat
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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.