Forum Discussion
Addition of time from multiple column
Hello @all, I want to add timestamp from different olumn and get the exact result. Any idea how it c
5 Replies
Anonymous sorry it did not worked and also time addition is different.....once it reaches to 60 it itself convert to 1 hour
Please see this article. You can convert all your time columns to decimal, do your math in a measure, and then format it at the end.
Calculate and Format Durations in DAX – Hoosier BI
Pat
No, I was saying that you should changed the types to number, did you use Int64.Type (whole number)? This way, 3AM becomes .125, 6AM becomes .25, 12PM becomes .5, and so on until a full day is 1. Since your example has the time stamps as time, so row 4 would equal 16 hours ten minutes, or about .67361111. Then you just convert that total back to a time, and you'll get 4:10 PM, and if you need that value as a duration, just wrap it all in Duration.From.
--Nate
Anonymous actually i need to find time differences from one stage to other.....and then there sum and then there average. what happening is whenever there is second value is less than first value it itself getting substract which occurs mismatch in time
