HOW DO I ADD CLOCK TIMES, WHEN DIRIVED FROM A FORMULA?
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. -- Andy. " m wrote in message ... 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?? |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com