look at Chip Pearson's site for the application.OnTime method
http://www.cpearson.com/excel/ontime.htm

Dates/times are stored as the elapesed number of days from a base date. To
get the elapsed number of hours

(End-Start)*24


--
Regards,
Tom Ogilvy

"Neil" wrote in message
...
I have a set of values that are being measure every 5
seconds, when the values are falling and hit a low point
I want to set a marker that is the time and date. some
time later maybe 1,2 or 3 days, it will drop again, and I
want to log another marker and work out the time in hours
between the two. I set of with a number of if then else
statements to decide how many days differance there were,
then tried to work out the hours but It all fell apart.
Is there any easy way of seting off a timer and then
stopping it ? I looked at the timer function but this
only gives the number of seconds since the last midnight ?