| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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?? |
|
#2
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Production CLock | Excel Worksheet Functions | |||
| Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
| Data Form Deletions | Excel Discussion (Misc queries) | |||
| Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) | |||
| subtracting times using 24 hour clock | Excel Worksheet Functions | |||
Linear Mode
