Deducting hours and minutes

Hi all,

Here’s my problem. Would it be possible to make an excel sheet and record my leave time?

I work 7 hours 24 minutes per day over five days a week. I have 229 hours per year; every day I take off I deduct 7hrs24mins.

I work flexi and some days I might just book 3hrs18mins if I want some time off, but this needs to be deducted off my running total.

I don’t want to start and design my form if I can't make it deduct and workout remaining time i.e hours and minutes

Regards

Hi,
I have just a small problem... Cell number column I row 31 will not format right!!!

I could I shorten my formula is column F row 5?

Go easy on me please as I am still learning about Excel...

Cheers