Hi Chip
I still can't get it to work
I've got 12/12/2003 09:00 in once cell and 11/12/2003
09:00 in the other
When I take the second away from the first I get 00:00:00
when it should tell me that 24 hrs has elapsed.
:o(
-----Original Message-----
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
.