Excel-changing value to 'time'

  graham√ 11:12 19 Jun 03
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 03

In Column C

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

and format Column C as Time.

  graham√ 11:40 19 Jun 03

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

  graham√ 12:10 19 Jun 03

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 03

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 03

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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…