Forum Discussion
Formula for calculating time
I am working on a formula for the following: If K95=Yes and X95=No the find the time difference in hours of Q110 (time stopped) and AP104 (time started again). These to cells are formatted like ...
Try this formula. You'll need to add sheet references if your formula and the cells you're referencing are on different sheets.
=IF(X96="Yes",0,IF(AND(K95="Yes",X95="No"),ABS(HOUR(X110)-HOUR(AP104)),""))