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,