Creating Hourly Time Format (0-23hrs)

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
To be clearer I want 01:00, 02:00, and 03:00 to read 00:00, 01:00 and 02:00.

Regards

RK
 
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 said:
To be clearer I want 01:00, 02:00, and 03:00 to read 00:00, 01:00 and
02:00.

Regards

RK

ExcelMonkey said:
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
Click to expand...
Click to expand...
 
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.
 
Back
Top