Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can anyone help!
I'm trying to enter a formula within a worksheet which references time. It should be quite simple but it doesn't work. eg =if(now()q13,"do this",if(now()q14,"do that","")) Both q13 and q14 are formated to the time format and contain the times 08:30 and 09:30 respectivly. I've been advised to use the MOD function, but this only provides the remainder, and produces an error within the formula. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Summing Time | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |