Forum Discussion

VivekBusi03's avatar
VivekBusi03
Frequent Visitor
4 years ago

Working Hours in power query

Hi All, 
I got stuck at a task which I was trying in Power Query. I have 2 columns (times) "LogOut" & "LogIn". Based on these columns I need a new column which shows the Time period between the "LogOut" & "LogIn" columns.

Thank You!

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • jgeddes's avatar
    jgeddes
    Icon for Super User rankSuper User
    4 years ago

    Table.AddColumn(#"Changed Type1", "workingHours", each Duration.From([logout]) - Duration.From([login]))

    will work as long as the login and logout columns are text type, not time type.

    • VivekBusi03's avatar
      VivekBusi03
      Frequent Visitor
      4 years ago

      Hi jgeddes ,
      Thanks for you the reply, I really appreciate for the solution.
      But it's throwing an error. at the end.