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