Does anyone know how to format hours in Excel to get a 0-23 axis for a daily
chart? I am currently doing the following and getting a 1-24 hours daily
chart. Ican't figure out how to make this 0-23 intead of

A B

[1] 1 ROUNDDOWN(A1,-2)/2400 +MOD(A2,100)/1440 = 01:00
[2] 2 ROUNDDOWN(A1,-2)/2400 +MOD(A2,100)/1440 = 02:00
[3] 3 ROUNDDOWN(A1,-2)/2400 +MOD(A2,100)/1440 = 03:00