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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Jenniss,

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

[hh]:mm

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

jenniss said:
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???
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How many are at work every hour in a 24-hour day? 2
Rounding up to nearest quarter, (:25, :50, :75, :00) 6
Hours over 10000:00 1
years-months-days-hours 5
Sum hours 1
How do I calculate time in excel (clock in and clock out 3
how do i round time down in excel? 7
Allocate Time Range over each hour of the day? 1

Back
Top