Author Topic: Date/Time stamp formate in Excel  (Read 744 times)

ClassicCrazy

  • Hero Member
  • *****
  • Posts: 1069
Re: Date/Time stamp formate in Excel
« Reply #15 on: January 17, 2017, 10:35:00 PM »
Hi,

I corrected the date formula in column A as you said and dragged it down to bottom and pasted it in so that seems good.

You can do it by: Ctrl-C to copy, Shift-Ctrl-Down, that highlights the whole column of data, then Ctrl-V to paste. I do it with a macro (time zone entry, cell error correction, copy/paste, & date/time format column).

Still, annoying after all these years.

dRdoS7

I did learn some those Control Shift arrow tricks  watching a youtube video the other day . Still have a ways to go on the graphing part though !
system one
Classic 150 , 20 Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system two
Classic 150 ,5s 135 watt Kyocero , 16s Calb 100AH LiFePO4 , Outback VFX 3648 inverter
system three
Midnite KID MPPT 24 DC in to  12 volt AGM batterie

ClassicCrazy

  • Hero Member
  • *****
  • Posts: 1069
Re: Date/Time stamp formate in Excel
« Reply #16 on: February 23, 2017, 02:41:53 AM »
I watched part of an Excel course and made some progress in graphing the Whizbang amps.
But I am sort of stuck on how to make my graph ( chart as they call it ) with better resolution. For example I would like to bring the bottom up from 0 to 10 amps and the top down to around 18 amps .

Is there an easy way to do that either in chart of any other way ?

John I see what you were talking about the noise - so today I had moved my ending amps from 10.8 up to around 11.2 . So I am hoping I could better analyze what it is doing from the chart .

So I am  getting there !


Larry
« Last Edit: February 23, 2017, 02:55:50 AM by ClassicCrazy »
system one
Classic 150 , 20 Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system two
Classic 150 ,5s 135 watt Kyocero , 16s Calb 100AH LiFePO4 , Outback VFX 3648 inverter
system three
Midnite KID MPPT 24 DC in to  12 volt AGM batterie

Resthome

  • Hero Member
  • *****
  • Posts: 996
Re: Date/Time stamp formate in Excel
« Reply #17 on: February 23, 2017, 11:13:58 AM »
I watched part of an Excel course and made some progress in graphing the Whizbang amps.
But I am sort of stuck on how to make my graph ( chart as they call it ) with better resolution. For example I would like to bring the bottom up from 0 to 10 amps and the top down to around 18 amps .

Is there an easy way to do that either in chart of any other way ?

John I see what you were talking about the noise - so today I had moved my ending amps from 10.8 up to around 11.2 . So I am hoping I could better analyze what it is doing from the chart .

So I am  getting there !

Larry

Click on the scale on the left until it is highlighted then right click on it and select Format Axis..

You can then change the MAX and MIN to Fixed values.

You can also add Minor lines by selecting Format Minor Axis after the doing the first step again.

Does that help?




Larry
John

10 x Kyocera KC140, Classic 150 w/WBJr, Link10 Battery Monitor, 850 AH @ 12v Solar One 2v cells, Xantrex PROwatt SW2000
Off Grid on Houseboat Lake Don Pedro, CA

ClassicCrazy

  • Hero Member
  • *****
  • Posts: 1069
Re: Date/Time stamp formate in Excel
« Reply #18 on: February 23, 2017, 01:07:51 PM »
Thanks John - yes that helped !

I knew there must be an easy way to do it .

Larry
system one
Classic 150 , 20 Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system two
Classic 150 ,5s 135 watt Kyocero , 16s Calb 100AH LiFePO4 , Outback VFX 3648 inverter
system three
Midnite KID MPPT 24 DC in to  12 volt AGM batterie