Ultimately, all I'm trying to do is calculate completed hours based on percentages from an original duration. I have the following in Google Sheets (manually entered for display):
The only columns I would like to manually enter values in, is the "Course Hours" and "Complete %". The "Completed Hours" and "Remaining Hours" columns are then calculated based on those values.
I'm sure there is a simple answer I'm overlooking here.