In article ,
Gord Dibben <gorddibbATshawDOTca wrote:
A1 is 8:00 AM

A25 is 10:00 AM

=(A25-A1)*24 returns 2 when formatted as General


Gord

On Wed, 19 Aug 2009 09:05:17 +0100, Dave Symes
wrote:

[Snip]

As another user of Excel who only uses it in a quite simple manner
compared to some of you power users... Firstly, thanks for the above
solution, and now to my question.

I have a column of times, increasing in 5 minute time increments from
8:00 to 10:00 (2 hours) if I SUM that column I get a time of 9:00
Bhaaa! so I'm an idiot.

What do I need to do to total that column and get the correct answer of
2 hours?


Thanks, that works a treat.

Dave

--