If you put 0:00 in the first row, 01:00 in the second row, and then drag down
to fill, you'll get what you want.
It isn't clear what you were trying to do with your formula.
--
David Biddulph


"ExcelMonkey" wrote:

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