T
toastnbutter
I am trying to find the best formula to demonstrate the length of time
it takes to perform tasks and then round them to quarter day
increments. For example, a task takes 10 hours to perform I need a
formula that will take the 10 hours and display 1.25 (assuming an 8
hour work day).
By the same token though if it is 10.5 hours it should roundup to 1.5
and not display 1.3.
Any help would be greatly appreciated.
it takes to perform tasks and then round them to quarter day
increments. For example, a task takes 10 hours to perform I need a
formula that will take the 10 hours and display 1.25 (assuming an 8
hour work day).
By the same token though if it is 10.5 hours it should roundup to 1.5
and not display 1.3.
Any help would be greatly appreciated.