How can i tell excel to cumalative the hours so 17:00 + 10:00 = 2.
 

I have designed a timesheet in excel thats works out staff hours.

I want excel to have a cumalative hours section so on a day to day basis
staff know how many hours they have done it total

I have done a formula to add up the hours but the problem is once it reached
23:59 it goes back to 0:00

does anyone know how to do cumaltive hours and resolve the problem???

Jenniss,

Format the cell (Format - Cell - Number - Custom):

[hh]:mm

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"jenniss" wrote in message
...
I have designed a timesheet in excel thats works out staff hours.

I want excel to have a cumalative hours section so on a day to day basis
staff know how many hours they have done it total

I have done a formula to add up the hours but the problem is once it
reached
23:59 it goes back to 0:00

does anyone know how to do cumaltive hours and resolve the problem???

thankyou very much you answerd my question:)

"Earl Kiosterud" wrote:

Jenniss,

Format the cell (Format - Cell - Number - Custom):

[hh]:mm

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"jenniss" wrote in message
...
I have designed a timesheet in excel thats works out staff hours.

I want excel to have a cumalative hours section so on a day to day basis
staff know how many hours they have done it total

I have done a formula to add up the hours but the problem is once it
reached
23:59 it goes back to 0:00

does anyone know how to do cumaltive hours and resolve the problem???