Type in the interval that you want to use for the X-axis labels. The first axis label displays, then Excel skips labels until the number of your interval, and continues on in this pattern.

Easy way to calculate time difference in Excel using simple logic. A simple formula to calculate difference between two dates & times in Excel.