I need to get more specific than just days. I need to be able to determine how many hours and minutes that elapsed between the start and finish times.
By the way, I am having trouble with Colo's HTMLMaker. I had it working yesterday but today it gives me a compile error "'Can't find project or library". I checked the VBA Editor for a "missing" line but there wasn't one in the list. Any ideas?
Named Ranges are:
StartDT = Start Time (i.e. 11/05/2003 2:52:12 PM)
EndDT = End Time (i.e. 11/06/2003 1:34:16 PM)
DayStart = Start Time of work (i.e 7 am)
DayEnd = End Time of work (i.e. 5 pm)
HoildayList = Range of cells that are holiday (i.e. Dec 25th, etc), this isn't needed if there are none.