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