Urgent Formula help!!

Question

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?

hansvogelaar · Answer

Mookie88&nbsp;
Format the cell with the formula =G3/P3 as General, Number or Percentage.

mookie88 · Answer

Hi Hans, I have tried every single format and not one of them work. I believe the issue is the fact that it will not take the actual value of P3 and G3.

hansvogelaar · Answer

Mookie88&nbsp;
Could you attach a small sample workbook demonstrating the problem, without sensitive data?

mookie88 · Answer

Hi Hans, here it is. I've also noticed that when I copy and paste the tables into the other tabs, the date changes to 2025. I have updated it to 2021 on the attached ss.

hansvogelaar · Answer

Mookie88&nbsp;
The formulas for duration were incorrect. I have corrected them in the attached version.

Forum Discussion

Urgent Formula help!!

7 Replies

Resources