summing cells of Time

  • Thread starter Thread starter Don Scarbrough
  • Start date Start date
D

Don Scarbrough

I got an answere to my other message but the trouble is it
did not work -- --when summing a group of cells that have
time in then the help says use this formula =Sum
(cell:cell) if it is to be more than 24 hours the formula
is =sum(cell:cell)*24 the trouble is nomater how I
format the cells it still comes up either 0 or 0:00
 
Hi
format your target cell with the custom format [hh]:mm to prevent the
rollover after 24 hours
 

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

time adding in excell 6
Adding columns of times 8
Using SUM function to count hours BUT ignore Letters? 6
Formulas calculate the answer wrongly as 0 1
Nested If functions and Formulas 5
Error when using Sum command 3
Sum number range ignoring numbers formatted as text 0
Calculating Times for Pay Rates 4

Back
Top