This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have the following formula that does not give me a "Zero" value even though the calculation should equal that.
The Formula is: =IF(J11<=0,"",(W11-V11))
The Cell W11 has the following formula in it: =IF(J11<=0,"",(F11-C11)+(J11-G11)+(G11-F11)) these values equal to 8.00.
The cell V11 has the following entry 8:30:00 AM.
The formulas in W11 are times during the day like: Clock in, morning break, (15 minutes) lunch break (30 minutes) and afternoon break (15 minutes).
The value shown comes out to 0.02. Why?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I assume you meant to write that W11 contains 08:00:00. That is, the time value for 8 hours. If than V11 contains 08:30:30 (the time value for 8 and a half hours) the difference between the two is 30 minutes. Half an hour or 30 minutes has a decimal value of 0.5/24 or 30/1440 = 0.02083333. What's not correct here?