I'm trying to create one formula that calculates the duration between two fields and then round it to the nearest 1/4 hour.
Right now I'm using two separate formulas in two separate columns and I want to consolodate my steps. For example:
I'm calculating the duration between 2011-06-17 06:26:28 and 2011-06-17 06:46:28 using =($L2-$J2)
then rounding it using =ROUND($k2-$m2)*96,0)/96 then rounding to the nearest 1/4 hour using =ROUND($M2*96,0)/96
There has got to be a more efficient way to consolodate the calculation into one cell but I'm struggling. Any thoughts?
Lesley
Right now I'm using two separate formulas in two separate columns and I want to consolodate my steps. For example:
I'm calculating the duration between 2011-06-17 06:26:28 and 2011-06-17 06:46:28 using =($L2-$J2)
then rounding it using =ROUND($k2-$m2)*96,0)/96 then rounding to the nearest 1/4 hour using =ROUND($M2*96,0)/96
There has got to be a more efficient way to consolodate the calculation into one cell but I'm struggling. Any thoughts?
Lesley