I see what you're saying, but this is going to be done in a form an
then saved to a database, so the formatting has to be done in code. Th
other problem i'm having is the the startTime and endTime variables ar
storing the same value from the Now() function. Here is the code:

Dim startTime, endTime
startTime = Now()
endTime = Now()
MsgBox (startTime)
MsgBox (endTime)
MsgBox (Format(startTime - endTime, "HH:MM:SS")

--
Message posted from http://www.ExcelForum.com