Chart time exis

[SandsB]

My chart's fine but I want the Y axis to show multiples of 15 seconds, not the random, daily changing number I get now. The top value will never be over 2 minutes so how can I make my chart always show 15, 30, 45, 60, 85, 90, 105, 120 seconds?

 

[Kaper]

If your time is real time, not a number of seconds, then go into axis formatting, set minimum to 0, max to 0.001388889 and major unit as 0.000173611

If these are seconds number use 0; 120 and 15

Minor units can be left set to automatic (because you probably don't use it)

 

[SandsB]

Perfect. Thank you. But how do you get those numbers? If I wanted 43 minutes or 112 minutes or.....

 

[Asbestos_Jen]

Divide seconds as a whole number by 60 (sec/min), then by 60 again (min/hr), then by 24 (hr/day). In time sequences for Excel, 1=1 day.

Book1
	A	B	C
4	Seconds	elapsed time	decimal
5	15	0:00:15	0.000174
6	30	0:00:30	0.000347
7	45	0:00:45	0.000521
8	60	0:01:00	0.000694
9	85	0:01:25	0.000984
10	90	0:01:30	0.001042
11	105	0:01:45	0.001215
12	120	0:02:00	0.001389
Sheet1

Cell Formulas
Range	Formula
B5:C12	B5	=$A5/60/60/24

 

[Kaper]

so 43 minutes is
=43/24/60
or
=TIMEVALUE("00:43:00")

and format the cell as general
- you will see that 43 minures is almost 3% of the day ( 0.029861111)

and similar for 112 minutes - either
=112/24/60
or
=TIMEVALUE("01:52:00")