I need Excel to calculate G3/P3. Both cells already contain a formula and are in the custom format h:mm:ss and need to stay in that format. When I try to calculate the simple division above, Excel provides a ridiculous number not even close to what I'm after. Does anyone have any suggestions?
Thanks Hans, I have since fixed it. I needed the duration to remain in the format h:mm:ss so I had to adjust the formula in column S so that it multiplied to get it to seconds. Was my only option to keep all the formatting the same. I do appreciate you taking the time to look into this. Cheers, Brooke