LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Issam LAdki
 
Posts: n/a
Default What is Wrong with this formula please?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What wrong with VLOOKUP formula TARZAN Excel Worksheet Functions 2 January 31st 05 10:09 PM
Formula "=num.de.semana(Date,2or1)" is WRONG for 2005 MrExcel77 Excel Worksheet Functions 1 January 5th 05 07:13 PM
Formula Result Correct but value in the cell is wrong jac Excel Worksheet Functions 2 December 17th 04 08:05 PM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 08:37 PM
Paste is is copying in formula, but display is wrong. Matt Excel Worksheet Functions 2 December 7th 04 08:37 PM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"