On Tue, 21 Aug 2007 16:20:24 -0400, Crackles McFarly
sayd the following:

On Tue, 21 Aug 2007 11:44:55 -0600, JE McGimpsey
sayd the following:

XL stores times as fractional days, so one can simply subtract the
earlier one from the later one. However, if the times span midnight, the
"later" time will actually be smaller than the earlier time (e.g., 3:00
am = 0.125, 6:00 pm = 0.75), so one needs to correct for that span. One
way:

=A22-A1 + (A22<A1)

takes advantage of XL's coercing TRUE/FALSE to 1/0.

Another:

=MOD(A22-A1,1)





In article ,
Crackles McFarly wrote:

12:15 pm
12:44 pm
12:45 pm
12:59 pm
then
12:01 am
12:09 am
12:19 am

The differences aren't the same, they change and that is that Number I
wish to calculate/display in another Cell

With about 22 entries in between, not of the same interval.

I'd REALLY appreciate some help with this problem.

How can you subtract the times each time so you can Display the "time
interval"?


thanks folks,,,


Hold up a sec folks.

I noticed the only way to get a result you can read or know is to set
the cell with the answer as a TIME format..I noticed their is no way
to just get some result number like 22 or 55, it has to be some format
like 15:00:00 or 00:15:00 for 15 mins as an example.

Anyway to get a result which is just a single number?


thanks a lot.