I receive pre-printed time sheets at work that have been manually filled in
by operatives, e.g Time of work: 9am-5pm. They will then have the hours
worked manually summed. I want to be able to check to make sure that these
are the correct hours by creating a formula to deal with this.
Later on I would like to create a formula that deals with over-time rates,
but I will deal with that later.
I'm a relative newcomer to Excel; Nested IF functions is about as the depth
of my knowledge.