Add hours to datetime

[Anonymous]

Hi,

I'm trying to add duration to start time in order to get the end time using the #duration () function, but seems it doesn't accept decimals as I understand the duration function does account the minutes and seconds 😁.

[StartDateTime]+#duration(0, [#"Duration (Hrs)"], 0, 0)

This is the result:

when Duration type is changed to whole number:

Is there a way to work around this? do I need to break the decimal hours to minutes and seconds???

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try this instead. It converts your decimal hours values to seconds before adding:

[StartDateTime] + #duration(0, 0, 0, [#"Duration (Hrs)"] * 3600)

Pete

[Anonymous]

Hi BA_Pete

WOW, I've never think of this!! Super easy solution.

always think out of the box 🙂

[BA_Pete]

No problem, happy to help.
Don't forget to give a thumbs-up on any posts that have helped you ‌‌👍

Pete