Calculation of differences in Date and time in Microsoft Excel values

Software

In Excel, dates are stored as a number. Technically, the value of a date is stored internally as the number of days since 31/12/1899. To test this, just enter number 1 in any cell, then right click on the cell and choose Format from cell. Change the format of Date and click OK. Now, you will see the date 01/01/1900. It is a day since 31/12/1899.Conveniently, the values are stored internally in fractions...Read More

Posted: 21 Apr 2012

Tags: Calculation of differences in Date and time in Microsoft Excel values Calculation differences Date and time Microsoft Excel values

Adding two values with IF statement

Office

Question:I have two forms using the instructions IF. I would like to take the calcuations of the two and add them together but not very well how to do.The same cell contains the following formulas:"1. = IF(AG3="Y",(0.3*0.5*K3)/100," ")"2 = IF (AE4 > 0, IF (I4 = "S",(M4-AE4): 100, IF (I4 = "B", (AE4 - M4) "/ 100," "")) "," "")What must occur if two formulas in the same cell and the value of each...Read More

Posted: 30 Mar 2012

Tags: Adding two values with IF statement Adding two values with statement

Unable to field table links values based on NULL values

Office

Question:I need some help creating a DLookup() statement or elookupAt the present time I haveDLookUp ("maxofdtapproR", "qry_dtapproR_Max", "(([PlanifIngId]_="_&_[tbl_Planification_Ingenierie].)) ") [[] PlanifIngId] & ") and ([NoEmission] ="& [qry_dtApproP_Max_ApproGestion].")" [[] NoEmission] & "))")The problem I have is that [NoEmission], which is a number, is not always a value. This...Read More

Posted: 30 Mar 2012

Tags: Unable to field table links values based on NULL values Unable field table links values based NULL

Is there a simple syntax to search Outlook items contain partial words or generic values?

Office

Question:I just spent 30 minutes frustrating to find that when type part of a word in the search box in Outlook 2010, Outlook does not index on the values of the substring, and is therefore no objects found. Well, duh!And many clicks later I used the tools of "advanced search" button in the "Tools" Ribbon and managed to open the awkward contextual search wizard that allows me to select the document...Read More

Posted: 27 Mar 2012

Tags: Is there a simple syntax to search Outlook items contain partial words or generic values there simple syntax search Outlook items contain partial words generic values

Entering values depending on the color of cell

Office

Question:I try to do the following, but it does not work. I don't know if I have the code in the correct section or not.Private Sub Worksheet_SelectionChange(ByVal_Target_As_Range)If Range ("B11").Interior.ColorIndex = vbRed thenRange ("M11").Value = 1If Range ("B11").Interior.ColorIndex = vbYellow thenRange ("M11").Value = 5End IfEnd IfEnd SubAnswer:That worked. Is there a way to get to a range of...Read More

Posted: 06 Mar 2012

Tags: Entering values depending on the color of cell Entering values depending the color cell