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 ...