Forum Discussion
ThiagoDuarte
4 years agoHelper I
Add integer (minutes) to datetime
Hello guys, I need to add an integer to a datetime to get the final date (date time format) I have the start date column and the duration in minutes as an integer. I need datetime fo...
- 4 years ago
New Time1 = MAX('Table'[Time]) + MAX('Table'[Integers])/24/60Hi ThiagoDuarte Try this.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
amitchandak
4 years agoSuper User
New column = [Start Date] + time(0,[Duration(Minute]), 0)
- ThiagoDuarte4 years agoHelper I
it doesn't work
the column duration minutes have values over 3000
- Nathaniel_C4 years agoCommunity Champion
Hi ThiagoDuarte Try
[Time]+#duration(0,0,[Integers],0)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel- Nathaniel_C4 years agoCommunity Champion
Hi ThiagoDuarte
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel