Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Fist off, big thanks to Chip Pearson who answered my last querry here
with a pointer to his site-- great stuff there, thanks! Here is my next problem-- simple I am sure, but i haven't a clue... In Cell e1 I have a time, in one of the standard time formats. I need to run some code if the current time is at least 5 minutes later than the time in e1. The IF, THEN statement seems obvious enough, but what goes in the place of the question marks below? Does each numeral equal a second, so for 5 minutes it would be 60*5, or 300? Apparently not, 300 doesn't = 5 minutes I have fingured out through trial and error.... So what should go in place of the question marks below to equal 5 minutes?? Arggg!!!! Thanks in advance for the help and/or explanation! If (Now() (e1 + ????)) Then |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
make chart based on equation | Charts and Charting in Excel | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
How to make one column be the result of an equation between two | New Users to Excel | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) |