To check a condition, we have to use a logical operation that only results in Boolean values (TRUE or FALSE). But multiplying TRUE or FALSE with the sum_range will only result in 0s. So, to convert those boolean
To fix this, you can either add the date portion to the starting time or use INT() function which will trim the day value returned by the NOW() function. First, enter starting date and time in a cell(s), then, enter the same formula. Make sure to apply the appropriate time format ...