|Don't be embarrassed. Working with Dates & Time in Excel is far from straightforward.|
This might help:
Excel stores Dates and Times as numbers, with the integer portion of the number being the day (using 1/1/1900 as Day 1) and the decimal portion being a fraction of a day.
For example, I just entered =NOW() in a cell and it displayed:
12/15/10 12:53 PM
I formatted the cell as a number and it displayed:
because 12/15/2010 is the 40,527th day since the beginning of Excel time, and
.5378762731 * 24 = 12.909 or almost 13 hours into the day.
That's why you can do "simple" math with Excel Dates and Times.
e.g. Add 1 for each day, add 1/24 for each hour
The point where it gets very tricky is when you are adding or subtracting times that cross the pesky Midnight threshold.
Posting Tip: Before posting Data or VBA Code, read this How-To.