Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Between 2 intervals
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating date/time intervals?? | Excel Worksheet Functions | |||
Time Clock Intervals | Excel Discussion (Misc queries) | |||
SUM-ing date for different time intervals | Excel Worksheet Functions | |||
comparing time intervals | Excel Worksheet Functions | |||
Time Intervals | Excel Worksheet Functions |