Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
The formula below does not seem to work, can somebody please tell me that is
wrong Cell A1 = Time ,e.g. 12:30:00 Cell B1 is blank Cell C1 = Time , e.g. 04:30:00 Cell D1 has following formula =IF(C1<MOD(A1+TIME(32,0,0),1),"ERRe2,C1+TIME(7,0,0 )) Basically is the time in C1 is less than A1 plus 32 hours, D1 will show error otherwise it is D1 plus 7 hours. I get the ERR in D1 if time is less, but not the D1 plus 7. Can somebody please advise when am I going wrong, and thanks a lot for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What wrong with VLOOKUP formula | Excel Worksheet Functions | |||
Formula "=num.de.semana(Date,2or1)" is WRONG for 2005 | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions |