A21001440 To add 200 seconds to the start time in A2. With Shortcut of F4 you only can change one cell reference at once time if there are multiple cell formulas need to change as below screenshot shown how can you quickly handle it. The TIME function allows you to build a time value on the fly using three arguments.
Times in Excel are factional values of 24 hours.
In the formula A2 contains the datetime field 12 is the hours you need to add to the datetime field. The TIME function allows you to build a time value on the fly using three arguments. B3TIME 800 Press Enter key then the result is shown. Cell D4 in Figure 4-20 contains this formula.