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