You can simply subtract the start time from the end time. The
result will be a number that represents a fraction of a 24 hour
day. Multiply this by 60*60*24 to get the number of seconds.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"animal1881 " wrote
in message ...
I made minesweeper using excel. Works pretty well. The only
prolem is
I can't figure out how to subtract a starting time from an
ending time
grabbed using

with DateTime
TimeValue(.Now)
end with

Does anyone know how to subtract times from each other? As in

DeltaTime = Time2-Time1?


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