HOW DO I ADD CLOCK TIMES, WHEN DIRIVED FROM A FORMULA?

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

Guest

I want to sum a column of date which contains formualted CLOCK TIMES. I keep
getting 00:00:0, as my sum. When I manually ENTER THE TIMES, THEN SUM THEM I
GET WHAT I NEED, HOWEVER I NEED THIS AUTOMATIC, NOT MANUAL. ANY IDEAS??
 
Hi
What format do you want your answer? If you want hours and minutes, and your
cells are proper Excel times, the result should be as expected if you format
the cell as [hh]:mm
If this is not correct, post some of your 'times' for us to see, and also
post the formula you are using to get the total.
 
You must log in or register to reply here.

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

Daily Time Sheets with Rounding 1
Time Sum in Excel 1
How enter time DURATIONS mm:ss (not clock times), then sum? 1
Conditional Time Calculation 10
Adding Hours & Minutes 3
Negative Dates and/or Times 3
Adding Times 7
excel 2003 (11.8307.8221) SP3 - custom cell formatting question 2

Back
Top