@ kchiba
This works perfectly. Thank you. Mathematics wins everytime!
And I'm on UK time, so this was a perfect start to the day.
Kind regards to all who helped.
This is for a management ot recording tool. Yes it would be 2.25 hours! I am mentally incapacitated from thinking too hard...
The time is entered by the sheet owner so will be single user.
Start and finish time are in adjacent cells, and the shift time is already calculated.
What I need...
Hello Guru's,
I have tried and failed numerous times with this problem.
I'm creating a time sheet and need to record any time that is worked between the hours of 16:00 and 19:00. The time can only be entered in 15min increments ie 01:15, 21:45 etc.
So if for instance someone works from...