Forum Discussion
Add hours to datetime
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???
Hi Anonymous ,
Try this instead. It converts your decimal hours values to seconds before adding:
[StartDateTime] + #duration(0, 0, 0, [#"Duration (Hrs)"] * 3600)Pete
3 Replies
Hi Anonymous ,
Try this instead. It converts your decimal hours values to seconds before adding:
[StartDateTime] + #duration(0, 0, 0, [#"Duration (Hrs)"] * 3600)Pete