You can insert a new column E and in E1 put in this formula:
=D1 + D2
assuming these are in Excel date and time formats. Use Format | Cells
to give the cell a Custom format. If this is the only record, then
select E1 and click <copy>, then Edit | Paste Special | Values (check)
| OK then <Esc>. Then you can delete column D.
If you have more than one record then you can copy the formula in E1
down to cover the records that you have, and then fix the values in
column E as described above. Delete column D, then sort the records so
that the blank rows (except fot the value in column D) will drop to
the bottom, where you can easily delete them.
Hope this helps.
Pete
> Hi Everyone,
>
[quoted text clipped - 7 lines]
>
> Thanks
Linda RQ - 03 Apr 2008 19:40 GMT
Nice and easy. Thanks!
You can insert a new column E and in E1 put in this formula:
=D1 + D2
assuming these are in Excel date and time formats. Use Format | Cells
to give the cell a Custom format. If this is the only record, then
select E1 and click <copy>, then Edit | Paste Special | Values (check)
| OK then <Esc>. Then you can delete column D.
If you have more than one record then you can copy the formula in E1
down to cover the records that you have, and then fix the values in
column E as described above. Delete column D, then sort the records so
that the blank rows (except fot the value in column D) will drop to
the bottom, where you can easily delete them.
Hope this helps.
Pete
On Mar 30, 1:44 am, "Linda RQ" <RomulanQu...@Work.SSTNG> wrote:
> Hi Everyone,
>
[quoted text clipped - 7 lines]
>
> Thanks
Pete_UK - 04 Apr 2008 00:22 GMT
You're welcome, Linda - thanks for feeding back.
Pete
> You can insert a new column E and in E1 put in this formula:
>
[quoted text clipped - 30 lines]
>
> - Show quoted text -
Probably best to keep separate for future filtering.
This should do it.
If you do NOT want to delete the row with the time then delete the
rows(i).delete line
Sub movecellupandover()
Columns("e").Insert
For i = Cells(Rows.Count, "d").End(xlUp).Row To 2 Step -2
Cells(i, "d").Cut Cells(i - 1, "e")
Rows(i).delete
Next i
End Sub
A B C D E F
1 2 3 1-Jan 10:32 5 6
1 2 3 2-Jan 11:32 5 6
1 2 3 3-Jan 12:32 5 6
1 2 3 4-Jan 13:32 5 6
1 2 3 5-Jan 14:32 5 6

Signature
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
> Hi Everyone,
>
[quoted text clipped - 7 lines]
>
> Thanks
Linda RQ - 03 Apr 2008 19:42 GMT
Thanks Don...this looks advanced. Pete's works but I want to try yours too
when I have a little more time
Linda
> Probably best to keep separate for future filtering.
> This should do it.
[quoted text clipped - 27 lines]
>>
>> Thanks