Libby,

You can just subtract one datetime value from another. In the
result cell, use a custom number format of [hh]:mm:ss .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Libby" wrote in message
...
Hiya folks

I had a spreadsheet with two columns. One column contained
dates, the other contained times.
I put the dates and times in one column, but if this can
be done without doing that, then feel free to post that
too :o)

What I need to do is to take one date/time away from
another to find out how many hours/mins/sec has elapsed
between the two

EG
12/Dec/2003 13:12 - 11/Dec/2003 09:50

Does anyone have any ideas?

Thanking you
Libby