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