Adding Hours & Minutes

[Paul Black]

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

 

[Mike H]

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]

Hi Mike,

That works perfectly.

Thanks very much.
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

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 -