| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time: problems with Sum
Hi,
I am trying to add up Time values - problem is Sum returns 0. Looking at the values, they appear to be text - here is a sample: 000:02:30 000:14:50 000:00:00 They are imported from somewhere - I guess I need to convert them into time values first. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time: problems with Sum
One way:
Select your cells. Choose Edit/Find Find: 000 Replace with: 0 In article , Mark wrote: Hi, I am trying to add up Time values - problem is Sum returns 0. Looking at the values, they appear to be text - here is a sample: 000:02:30 000:14:50 000:00:00 They are imported from somewhere - I guess I need to convert them into time values first. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Still problems with calculation of time | Excel Worksheet Functions | |||
| Problems with Time!! | Excel Discussion (Misc queries) | |||
| time problems | Excel Worksheet Functions | |||
| elapsed time problems | Excel Worksheet Functions | |||
| Problems with time | Excel Worksheet Functions | |||
Linear Mode
