DashboardNovice
Member
The first tab in the attached file has a formula that shows how to deal with negative numbers when subtracting time. I got this from a video on YouTube.
Cell D11 would result in a negative value. In order to correct for this, they are using a comparison operator in the formula and adding that to a time value. How can time be added to a TRUE/FALSE value?
How does this comparison quantity correct for negative time values?

The second tab uses the NOW( ) to take the current time, then take the difference between the current time and some future time (example 1). In example 2, the NOW( ) takes the current time and calculates the difference based on a previous time in the day.
As of this posting Example 1 calculates just fine, but Example 2 doesn't.
I'm trying to come up with one formula that I can use in both cases. I thought the MOD( ) function would help, but it's not working the way I thought it would.
Cell D11 would result in a negative value. In order to correct for this, they are using a comparison operator in the formula and adding that to a time value. How can time be added to a TRUE/FALSE value?
How does this comparison quantity correct for negative time values?

The second tab uses the NOW( ) to take the current time, then take the difference between the current time and some future time (example 1). In example 2, the NOW( ) takes the current time and calculates the difference based on a previous time in the day.
As of this posting Example 1 calculates just fine, but Example 2 doesn't.
I'm trying to come up with one formula that I can use in both cases. I thought the MOD( ) function would help, but it's not working the way I thought it would.
Attachments

11.3 KB Views: 10
Last edited: