Hi Jaz:
Let us go systematically -- once we have got the basics pat, it would be smooth sailing. As I mentioned in my posts as well as in my simulation(s), time is shown with hours and then a colon and then minutes, so since there are 60 minutes in an hour, we do not talk of time as being 15:84
Now if you hav time as 15 hour and 84/100 of an hour that is not shown as 15:84, but instead it will be shown as 15.84 hours -- Fair enough! Excel has its own lingo, and if we are going to work with Excel, the sooner we get past these nuances, the better.
So, if you are still with me,
tell me what is the StartTime
whether you tell it to me in Hours and Minutes, or in Hours and decimals of an hour, be clear about it and know the difference
and then tell me what is the QuitTime
again whether you tell it to me in Hours and Minutes, or in Hours and decimals of an hour, be clear about it and know the difference
Once we clearly know what is the QuitTime, and what is the StartTime, how long one actually worked is simply a matter of subtracting the StartTIme from the QuitTime
So, provide the requested information -- and then let us take it from there.