Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi Anonymous ,

     

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

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

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

Hi BA_Pete

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

always think out of the box 🙂

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

     

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

     

    Pete