Urgent Formula help!!

%3CLINGO-SUB%20id%3D%22lingo-sub-2791555%22%20slang%3D%22en-US%22%3EUrgent%20Formula%20help!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2791555%22%20slang%3D%22en-US%22%3EI%20need%20Excel%20to%20calculate%20G3%2FP3.%20Both%20cells%20already%20contain%20a%20formula%20and%20are%20in%20the%20custom%20format%20h%3Amm%3Ass%20and%20need%20to%20stay%20in%20that%20format.%20When%20I%20try%20to%20calculate%20the%20simple%20division%20above%2C%20Excel%20provides%20a%20ridiculous%20number%20not%20even%20close%20to%20what%20I'm%20after.%3CBR%20%2F%3EDoes%20anyone%20have%20any%20suggestions%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2791555%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2791779%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20Formula%20help!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2791779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1168846%22%20target%3D%22_blank%22%3E%40Mookie88%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormat%20the%20cell%20with%20the%20formula%20%3DG3%2FP3%20as%20General%2C%20Number%20or%20Percentage.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2793275%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20Formula%20help!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2793275%22%20slang%3D%22en-US%22%3EHi%20Hans%2C%20I%20have%20tried%20every%20single%20format%20and%20not%20one%20of%20them%20work.%20I%20believe%20the%20issue%20is%20the%20fact%20that%20it%20will%20not%20take%20the%20actual%20value%20of%20P3%20and%20G3.%3C%2FLINGO-BODY%3E
Occasional Contributor
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?
7 Replies

@Mookie88 

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

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.

@Mookie88 

Could you attach a small sample workbook demonstrating the problem, without sensitive data?

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.

@Mookie88 

The formulas for duration were incorrect. I have corrected them in the attached version.

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

@Mookie88 

If you want the duration as time, the formulas are even simpler.