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 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!
the function adds only whole number of hours by design, see documentation
you will have to add hours and minutes separately as Cassy Freeman suggests.
Thank you both!! Now...can either of you help with determining what the formula should look like? I separated the # of hours into 2 fields (# hrs and #mins). I'm coming up empty with each attempt to get a formula that brings everything together. I've just completely confused myself into almost giving up!!
this approach have 2 drawbacks...
While I hear and acknowledge your argument, I do not see any company policy allowing it's employees to apply for 5min leave, generally there is a standard which allows for half hours but not random amounts of minutes (I could be wrong but unlikely), I would instead add validation on the field to not allow random minutes. Imagine the nightmare random amounts of minutes would create for Payroll.