Forum Discussion
Urgent Formula help!!
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 pro...
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.
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.
