Mac excel graphing format axis number for an hour

broken image
broken image

1.125 for 1 am, so it falls on the next day and not the same day as the 9pm value. 0.875 for 9 pm, and the values after midnight should have a 1 before the decimal, e.g. At the very least, the time values for the first day should have a 0 before the decimal, e.g. If the time values go across midnight, you need to add a date part to the time value, so they can be plotted correctly as before and after midnight.