Forum Discussion
ThiagoDuarte
Helper I
Helper IAdd 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...
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
Super User
Super UserNew column = [Start Date] + time(0,[Duration(Minute]), 0)
ThiagoDuarteit doesn't work
the column duration minutes have values over 3000
- Nathaniel_C
Community 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_C
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