I have looked in all of the usual places, and have done several
searches on the web for an answer to this problem, and I am stumped.
It seems like it should be a simple answer, but I'm not seeing it. I'm
hoping someone here can help. What I have are two cells in a worksheet
that contain Date/Time Values. One is for starttime(B2) and one is for
endtime(B3). All I want to do is subtract the starttime from the
endtime and then display the difference(B4) in hh:mm:ss.

I was handling this with a simple formula on the sheet in B4:
=B3-B2
B4 is formatted for Time. This works great unless the date parts of
the date/time values are different days, because the date part of the
date/time value is ignored.

So now I figure I have to handle this in VBA, but don't have a clue
how to approach it. Can someone out there give me a nudge in the right
direction?