I have a time sheet I fill out at work, it's a basic excel spreadsheet and I wanted to automate it some. So I went online and found a formula that I plugged in to the "hours" column that are supposed to calculate hours worked based on the in/out times provided in other fields. It works great, except when it encounters 10:00 or 11:00 (AM/PM doesn't seem to matter).
This is the formula I'm using as it exists in one of the fields:
I've also attached a screen shot showing various sample in/out times and it's resulting calculations. Can anyone tell me what's wrong with the formula and how I can correct it?