Creating Hourly Time Format (0-23hrs)
 

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

Creating Hourly Time Format (0-23hrs)
 

To be clearer I want 01:00, 02:00, and 03:00 to read 00:00, 01:00 and 02:00.

Regards

RK

"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

Creating Hourly Time Format (0-23hrs)
 

What's is A1, and what's in A2?

Give us the A1 and A2 values that produce 01:00, 02:00 and 03:00

Regards,
Fred

"ExcelMonkey" wrote in message
...
To be clearer I want 01:00, 02:00, and 03:00 to read 00:00, 01:00 and
02:00.

Regards

RK

"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

Creating Hourly Time Format (0-23hrs)
 

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