Adding Hours & Minutes
 

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

Adding Hours & Minutes
 

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

Adding Hours & Minutes
 

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 -