A
AlEvanPA
I am new to VBA. I have an Excel Spreadsheet where each row is seperated by
an hour as shown below:
Date Time Col1 Col2
1/1/06 22:00 Val1 Val2
1/1/06 23:00 Val3 Val4
1/2/06 00:00 Val5 Val6
What I want to happen is to run a Macro (confugred with VBA) that does the
following to the input data:
Date Time Col1 Col2
1/1/06 22:00 Val1 Val2
1/1/06 22:01 Val1 Val2
1/1/06 22:02 Val1 Val2
....
1/1/06 22:59 Val1 Val2
1/1/06 23:00 Val3 Val4
1/1/06 23:01 Val3 Val4
....
1/1/06 23:59 Val3 Val4
1/2/06 00:00 Val5 Val6
1/2/06 00:01 Val5 Val6
....
1/2/06 00:59 Val5 Val6
, etc.
I am able to get the date and value columns to copy correctly, but have no
clue how get the time (minute) to sum.
Can someone please help.
Thank, In advance
an hour as shown below:
Date Time Col1 Col2
1/1/06 22:00 Val1 Val2
1/1/06 23:00 Val3 Val4
1/2/06 00:00 Val5 Val6
What I want to happen is to run a Macro (confugred with VBA) that does the
following to the input data:
Date Time Col1 Col2
1/1/06 22:00 Val1 Val2
1/1/06 22:01 Val1 Val2
1/1/06 22:02 Val1 Val2
....
1/1/06 22:59 Val1 Val2
1/1/06 23:00 Val3 Val4
1/1/06 23:01 Val3 Val4
....
1/1/06 23:59 Val3 Val4
1/2/06 00:00 Val5 Val6
1/2/06 00:01 Val5 Val6
....
1/2/06 00:59 Val5 Val6
, etc.
I am able to get the date and value columns to copy correctly, but have no
clue how get the time (minute) to sum.
Can someone please help.
Thank, In advance