I’m building a hour counting schema where you enter start time, end time, lunch and get a result of how long you have been at work.

Norman work day is 7 hours 30 minutes. I want to calculate the diffrence between my time at the office and 7:30.

I have tried this formula: =G16-7:30

It gives me #VALUE!

My spreadsheet: Pasteboard - Uploaded Image