ExcelBanter - Is arithmetic on time data possible in Excel 2002?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is arithmetic on time data possible in Excel 2002? (https://www.excelbanter.com/excel-discussion-misc-queries/140548-arithmetic-time-data-possible-excel-2002-a.html)

sleeplessinnewjersey

Is arithmetic on time data possible in Excel 2002?

I've imported a list of times (Hr:Min) into Excel from a Wordpad document.
Can Excel perform the following on this data?

Sum
Maximum
Minimum
Average

Peo Sjoblom

Is arithmetic on time data possible in Excel 2002?

Why don't you try?
Yes, as long as they are numerical Excel can do this
Sometimes when you "import" dates and times from another program they are
seen as text

--
Regards,

Peo Sjoblom

"sleeplessinnewjersey"
wrote in message ...
I've imported a list of times (Hr:Min) into Excel from a Wordpad document.
Can Excel perform the following on this data?

Sum
Maximum
Minimum
Average

All times are GMT +1. The time now is 08:20 PM.