why does subtracting two time columns not produce a time

[jrbrown00]

• I have table with two datetime columns for maximum and minimum.  Both have been changed from Datetime to Time  
  
• I am grouping them by runMonth. 
• I want the difference between max and min as a time.  My formula looks like this:
  = Table.AddColumn(#"Grouped Rows", "dtDifDuration", each [dtMaxRunDuration] - [dtMinRunDuration])
• The Power Query Editor decided the format should be numeric (ABC 123) instead of time
  
  
  
  
• When I change the type to Time, Power Query tells me it is an error. 
  

Help?

[v-angzheng-msft · Accepted solution]

Hi, @jrbrown00 

I had done research in this thread as to why the data types are different in the Power Query editor and the model after applying the changes.

Formating a column in Percentage does get applyed in data model

Hope it helps you.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft]

Hi, @jrbrown00 

Try this:
Time:

= Table.AddColumn(#"Added Custom", "Time", each #time( 
      Duration.Hours([dtDifDuration]), 
      Duration.Minutes([dtDifDuration]), 
      Duration.Seconds([dtDifDuration])))

DateTime:

=Table.AddColumn(
  #"Grouped Rows", 
  "DateTime", 
  each DateTime.From([Date])
    + #duration(
      Duration.Days([dtDifDuration]), 
      Duration.Hours([dtDifDuration]), 
      Duration.Minutes([dtDifDuration]), 
      Duration.Seconds([dtDifDuration])
    )

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

subtracting two time values produces a duration, not a time value.