I've calculated total hours worked in a google sheet. Lets say total hours worked appear in column 'Q'. In the next column over, column 'R', I need to calculate the total hours missing and I'm not sure how to do this.
So for example, say total hours worked is 7:30 (currently formatted as a duration in cell Q2), in R2 I entered:
=(8-Q2), which is a number minus a duration. The result was way off.
Anyone know how to do this?