Convert hours to %

Hello!

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!

Solved Solved
0 4 285
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4
4 REPLIES 4
Top Labels in this Space