Excel-changing value to 'time'

  graham√ 11:12 19 Jun 2003
Locked

My 'light on' chart created yesterday, thanks to Vog TM, is looking good. I am now trying to change the time from a decimal, ie. 9:20 shows as 9.2, to the time 9:20. When I change the format of column B to time, the value of 9.2 changes to 4:48, which I assume is a calculation of 9.2! If I then change 4:48 to 9:20, the chart goes all to pot. All this is probably irrelevent as there is an easy way to change the format!

  VoG® 11:38 19 Jun 2003

In Column C

=(INT(B7)+(B7-INT(B7))*100/60)/24

and format Column C as Time.

  graham√ 11:40 19 Jun 2003

Thanks as always, give me a minute to have a go!

  graham√ 12:10 19 Jun 2003

I've done that, but the chart now just shows hours from 0 to 10, no good for the small changes involved. Sorry to be a nuisance, I know it's difficult without hands on.

  VoG® 12:29 19 Jun 2003

Right click the Y-axis, select Format Axis. On the scale tab, set the scaling to suit.

You might want to tart-up some other things - font, alignment, ... - as well.

  graham√ 12:42 19 Jun 2003

Done that, but it's reverted to decimal, if I change it back to time I get 4:48 again! Mrsthokomatshe wants me to help her and her three (3) children as well!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone