The intervals are 4 hours, 8 hours, 12 hours, and 24 hours.

If a start time is changed, the future dates should recalculate as needed.

How Excel handles times

In Excel,dates are serial numbersandtimes are fractional parts of 1 day.

Excel formula: Convert decimal hours to Excel time

Date formatting

The display of dates in Excel is controlled bynumber formatting.

The custom number format used in the example is:

This format can becustomizedas needed.

Excel formula: Add decimal hours to time

Excel formula: Convert Excel time to decimal hours