'To add an hour to a date or time value in Excel... 'As a worksheet formula: =A1 + 1/24 'And it works in VBA as well: MsgBox Now + 1/24