Forum Discussion
Helper IHelp 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!
Helper IHello Anonymous!
First of all thanks for replying on the topic and I'll try to explain better what I need. I'm sorry if my english is a little bad, I'll try to exemplify:
Column1 Column 2
27/01/2017 10:30:00 30/01/2017 08:30:00
I need to be able to extract the whole amount of time (preferably in "hh : mm : ss") passed between these two columns, wich is 70:00:00. You mentioned I'd need to format as text to do it, wich won't help me very much because I'll eventually need to use them on a calculation or something, so how do I extract 2 days 22:00:00 out of it?
Thanks Lydia Zhang!
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,
- Tulio_DL
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!