Forum Discussion
Help needed!! Data modeling: Time
Hey guys! Thanks for repplying to my post... I've come to an acceptable way to do it with the formulas DATEDIFF (as mentioned above) and other minor ones.
So if you find yourself struggling with the same doubt as the topic plz msg me in box that I can send you the step to step and explanations!
Thank you Anonymous and vrs!
Hello Tulio_DL
Not sure about your need but I suggest you create two columns number of days and duration
| Column1 | Column 2 | Ndays | Duration |
| 27/01/2017 10:30 | 30/01/2017 08:25:23 | 2 | 21:55:23 |
Ndays= QUOTIENT(DATEDIFF(table[Column 1];table[Column 2];HOUR);24)
Duration= table[Column 1]- table[Column 2]
You can get duration in seconds DATEDIFF(table[Column 1];table[Column 2];SECOND), it can be useful if you need to compare different values.
Hope this helps,
Hey guys! Thanks for repplying to my post... I've come to an acceptable way to do it with the formulas DATEDIFF (as mentioned above) and other minor ones.
So if you find yourself struggling with the same doubt as the topic plz msg me in box that I can send you the step to step and explanations!
Thank you Anonymous and vrs!