Relative Content

Tag Archive for if-statement

If Else – Repeated Code Logic

My boss gave me a project with a particular logic. I have to develop a web page which has to lead the navigator through many cases until he/she arrives at the product.

If Else – Repeated Code Logic

My boss gave me a project with a particular logic. I have to develop a web page which has to lead the navigator through many cases until he/she arrives at the product.

If Else – Repeated Code Logic

My boss gave me a project with a particular logic. I have to develop a web page which has to lead the navigator through many cases until he/she arrives at the product.

If Else – Repeated Code Logic

My boss gave me a project with a particular logic. I have to develop a web page which has to lead the navigator through many cases until he/she arrives at the product.

how to make an if/then formula/statement that if a cell says 1700-1717 to then do the calculation

The sheet I am creating I have it so that when a cell has a value greater than 0 for a start time (put in 1700) then the cell changes to red. When I add and end time into the cell (1700-1717) it then turns green. Is there anyway to do an if/then either in excel itself or in VBA so that if excel sees me add the “- end time” into the cell it would then add the standard “=” in front of the 1700-1717 to give me an absolute time of 17 minutes in a separate cell while still keeping “1700-1717” in the original cell? The goal is to get a whole column of start and end times and do the simple subtraction in an absolute number to then get the overall average of the start and stop times in a separate cell.