Hi,

I have formatted the cells where I input the hours as hh:mm and
entered hours like start time of 8:15 and end time of 17:30. I then
take the 8:15 away from 17:30 and get 9:15 which is correct.
I have done this for several days, but when I try and calculate the
total hours worked to date I keep getting the wrong answer.
Any help will be greatly appreciated.

Thanks in advance.
All the Best
Paul

Hi,

format the cell where you add the times as [hh]:mm that way it won't roll
back to 1 as it passes 24.

Mike

"Paul Black" wrote:

Hi,

I have formatted the cells where I input the hours as hh:mm and
entered hours like start time of 8:15 and end time of 17:30. I then
take the 8:15 away from 17:30 and get 9:15 which is correct.
I have done this for several days, but when I try and calculate the
total hours worked to date I keep getting the wrong answer.
Any help will be greatly appreciated.

Thanks in advance.
All the Best
Paul

Hi Mike,

That works perfectly.

Thanks very much.
All the Best
Paul

On Sep 24, 11:28*am, Mike H wrote:
Hi,

format the cell where you add the times as [hh]:mm that way it won't roll
back to 1 as it passes 24.

Mike



"Paul Black" wrote:
Hi,

I have formatted the cells where I input the hours as hh:mm and
entered hours like start time of 8:15 and end time of 17:30. I then
take the 8:15 away from 17:30 and get 9:15 which is correct.
I have done this for several days, but when I try and calculate the
total hours worked to date I keep getting the wrong answer.
Any help will be greatly appreciated.

Thanks in advance.
All the Best
Paul- Hide quoted text -

- Show quoted text -