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"?