As a diabetic, I need to keep track of my blood sugar count and the time
elapsed between my last meal and when I test my blood sugar.

I have two Excel 2007 worksheets, BLOOD & MEAL in the same workbook. I
don't always test my blood sugar after every meal, so there is NOT a
one-to-one correspondence between entries in the two worksheets.

I don't keep both Meals & Blood Sugar in the same worksheet because I use
MEALS for keeping track of other things in addition to Blood Sugar.

What formula can I put into BLOOD, COL C to get the time elasped since my
last meal?

==============================
BLOOD
A B C
1 DATE_TIME BSC ELASPED_HOURS
2 01/02/08 06:00AM 099 8.00 <--------Formula to get this result?
3 01/02/08 09:00AM 225 1.00 "
4 01/02/08 06:00PM 155 1.00 "
5 01/02/08 07:00PM 162 2.00 "
6 01/03/08 06:00AM 091 8.50 "
7 01/03/08 10:30AM 222 1.75 "
8 01/03/08 12:15PM 125 1.25 "
9 01/03/08 07:30PM 133 2.15 "
==============================
MEALS
A B C
1 DATE_TIME
2 01/01/08 10:00PM
3 01/02/08 08:00AM
4 01/02/08 12:30PM
5 01/02/08 05:00PM
6 01/02/08 09:30PM
7 01/03/08 08:45AM
8 01/03/08 11:00AM
9 01/03/08 05:15PM
==============================
Thanks in advance,

Dick King