I am trying to get a % remaning from hours, provided by filling a form.
I tried this formula:
(100*(HOUR([Hours Completed])+MINUTE([Hours Completed])))/(HOUR([PG Contract Hours])+MINUTE([PG Contract Hours]))
but unfortunately, it seems to not work.
For exemple, my total of PG Contract is 60:00 and my Completed is 7:58, with this formula it gives me 108, instead of 13.27.
Thank you very much in advance!