Forum Discussion
Solved
Divide Date & Time Columns
Good day, How do I divide these two columns? When I attempted to do so by creating a custom column in power query it said I could not use the divide (/) operator. The calculation I am t...
Hi kingmeesh242 ,
How about this:
Here the M code:
Duration.TotalMinutes([Visit End Time] - [Visit Start Time]) / Duration.TotalMinutes(DateTime.Time([Visit Start Time]) - #time(0, 0, 0) )
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi kingmeesh242 ,
How about this:
Here the M code:
Duration.TotalMinutes([Visit End Time] - [Visit Start Time]) / Duration.TotalMinutes(DateTime.Time([Visit Start Time]) - #time(0, 0, 0) )
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/