In my gut, I feel I should know how to fix this. Alas...I cannot. I am working on a time-off request form for one of our managers and we are trying to come up with "creative" ways to get around not having a business days/hours function available to us. Currently, I'm trying out a date calculation for single day requests where someone enters the date and time they want off, then adds the number of hours off in the next field. My calculated value says "add hours to this date/time to get the end time" (at least that's what I want it to say). What I am finding, though, is that it works great, but with whole numbers only. If someone wants 2.5 hours off, it only calculates the 2 hours and does not include the additional 30 minutes.
My formula:
formatDate(dateAddHours(RequestBeginSingleControl,TotalHoursOffControl), "MM/dd/yyyy hh:mm tt") |
Results:
My first question: "What am I doing wrong?". Second question: "How do I fix this?"
Thank you in advance for your brain power during a holiday week!