How do I get difference between hours worked vs. required number

I have a report that has the number of hours we are to work (9). Then we have a column showing the number of hours we actually worked. Example: 8.44 = 8 hours and 44 min.

I then have a column that I want to show the difference between actual hours worked (8.44) vs. required number of hours to work (9).

Can anyone help me with this formula, I have been trying for 2 hours.

Thanks in advance.

I imagine that when you subtract 9 from 8.44 your answer is .56.

The reason is .44 + .56 = 1 (8+1 = 9)

If this true then what you try 9-8.44-.40. Always subtract .40

If you minus .40 that will give .60 as in 60 minutes.

If you're working with hours it's sensible to use excel's time format so that the calculations are easy. If A2 contains hours to work in the format 9:00 and B2 shows actual hours worked in the format 8:44 then the formula

=A2-B2

will give you the difference, i.e. 0:16

What do you want to show if hours worked is greater than hours to work, or isn't that possible?