Confused with Formula and IF function - Need to Pull out report at 3 PM today :(

[Zaid]

Dear All,

See attached file.

I have Column F "Extra Hours". Now looking at this column i want some status description in Column H

Here are the conditions:

If Extra Hours is < 00:00 -- SHORT FALL
If Extra Hours is between 05:00 and 10:00 -- > 5 Hr.
If Extra Hours is between 10:00 and 20:00 -- > 10 Hr.
If Extra Hours is greater than 20:00 -- > 20 Hr.

Since column F in in HH:MM format i have tried to multiply it by 24 and tried to do the same with column G but no success.

Please advise.
Regards
Mohammad