Time formula going back to zero?

Try formatting your sum as [h]:mm:ss ( see format cells - custom)
That should help

no. it still shows up as 0 if more than 3 times are entered. if i only enter 1 time or times then it will add it. but for some reason 3 or more is still 0

When you add more tha three, is the total more than 24 hrs?
Also if you attach a sample file we can see what is going wrong

Yes three 8 hours shifts makes it 24 hours. If i use smaller shifts, i can include more than 3. so i guess its a 24 hour thing?


I thought about attaching the file, but i am unsure of where i would upload it to link to it.

Under the reply box click "go advanced"
Click on the attachments link and upload your sheet

of course its that easy. well i already uploaded it here

http://www.filefactory.com/file/b0eg...yrollcalc.xlsx

but here is the xls too

I added some intervals to your sheet and formatted as I suggested and it works OK.
Is that what you need ? ( see total in red)

Yes you are my hero! I did change it like you said but it did not work for me =/

what do you mean by you changed intervals?

Just added some hours to go over the 24

Well i don't know why it worked for you, and not me. But thanks!!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

ok, now its not working again.

i changed the shifts, making them longer one week 64 hours. to try and see if overtime formula worked. number are not adding right again!!!

Everything looks right. Where do you get an error?

BTW avoid AT ALL COSTS using merged cells, they will cause trouble if you need them to analyze data

At the top where it has the summary. week 1 regular hours should be 40 not 16.

Same thing, wrong format ! you should use [h]:mm:ss the h has to be between "brackets"

oh, thanks!