ExcelBanter - Time: problems with Sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time: problems with Sum (https://www.excelbanter.com/excel-worksheet-functions/216488-time-problems-sum.html)

Mark

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?

JE McGimpsey

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?

All times are GMT +1. The time now is 07:28 PM.