how to delete Rows in excel (row times: from~to)

A

alimadhi

New Member
Joined
Sep 14, 2014
Messages
8
hi , i want delete multi rows i have a lots of excels sheets recording time in Ms i want delete between Ms and keep them just every mint recorder

for example:- see blow recorder time in red mark

[TABLE="width: 571"]
<tbody>[TR]
[TD="align: left"]Time[/TD]
[TD="align: left"]dwatt2[/TD]
[TD="align: left"]L33TUC_FLT[/TD]
[TD="align: left"]l33tuc[/TD]
[TD="align: left"]DF[/TD]
[TD="align: left"]l20fa1x[/TD]
[TD="align: left"]hftout[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:45[/TD]
[TD="align: right"]29.10786[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.17484[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:45[/TD]
[TD="align: right"]27.9434[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.19516[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]28.25409[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.21163[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]28.33318[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.2281[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]27.60696[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.23731[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]27.64434[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.2572[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]27.96513[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.27759[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]27.61231[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.29751[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]26.07797[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.33837[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]26.06944[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.36613[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]25.04375[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.40077[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]23.88965[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.41932[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]24.33256[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.44131[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]22.60748[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.45794[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]23.06262[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.47849[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]23.36586[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.48927[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]22.28431[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.49417[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]22.8875[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.50838[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]23.01399[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.51671[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]21.87897[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.54517[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]21.91144[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.56334[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]21.88628[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.57317[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]22.12372[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.58792[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]22.22739[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.59874[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]22.05495[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.6081[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]22.24202[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.61942[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]22.25443[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.62877[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]22.32067[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.63863[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]22.31877[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.64799[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]24.25901[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.65095[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]23.55493[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.64799[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]23.61375[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.64948[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]24.74718[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.65835[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]24.82937[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.66772[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]24.81699[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.67167[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]26.04348[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.67167[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]26.08807[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.67808[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
</tbody>[/TABLE]

to :-

[TABLE="width: 571"]
<tbody>[TR]
[TD="align: left"]Time[/TD]
[TD="align: left"]dwatt2[/TD]
[TD="align: left"]L33TUC_FLT[/TD]
[TD="align: left"]l33tuc[/TD]
[TD="align: left"]DF[/TD]
[TD="align: left"]l20fa1x[/TD]
[TD="align: left"]hftout[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:45[/TD]
[TD="align: right"]29.10786[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.17484[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:46[/TD]
[TD="align: right"]28.25409[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.21163[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:47[/TD]
[TD="align: right"]23.06262[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.47849[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
[TR]
[TD="align: right"]30/08/2014 15:48[/TD]
[TD="align: right"]22.24202[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49.61942[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Can't you just use Remove Duplicates on the Ribbon's Data tab? Here it is in VBA:

Code: 
Sub Test()
    ActiveSheet.Range("A1").CurrentRegion.RemoveDuplicates Columns:=1, Header:=xlYes
End Sub
 
Upvote 0
No Duplicates because the seconds is different :(

06/09/2014 11:04:13 AM
06/09/2014 11:04:18 AM
06/09/2014 11:04:23 AM
06/09/2014 11:04:28 AM
ETC...
 
Upvote 0
[TABLE="width: 495"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD="align: left"]Time[/TD]
[TD="align: left"]dwatt2
[/TD]
[TD="align: left"]L33TUC_FLT[/TD]
[TD="align: left"]l33tuc
[/TD]
[TD="align: left"]DF
[/TD]
[TD="align: left"]l20fa1x[/TD]
[TD="align: left"]hftout[/TD]
[/TR]
[TR]
[TD]11:04:13 AM[/TD]
[TD="align: right"]83.25909[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61958[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100
[/TD]
[/TR]
[TR]
[TD]11:04:18 AM[/TD]
[TD="align: right"]82.9603[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61548[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:23 AM[/TD]
[TD="align: right"]83.01331[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.62573[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:28 AM[/TD]
[TD="align: right"]83.51387[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.63137[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:33 AM[/TD]
[TD="align: right"]83.92419[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.62368[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:39 AM[/TD]
[TD="align: right"]83.75002[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61958[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:44 AM[/TD]
[TD="align: right"]84.42615[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61856[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:49 AM[/TD]
[TD="align: right"]84.07156[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61958[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:54 AM[/TD]
[TD="align: right"]84.23187[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61907[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:04:59 AM[/TD]
[TD="align: right"]84.15089[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61138[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:04 AM[/TD]
[TD="align: right"]83.75203[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60934[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:09 AM[/TD]
[TD="align: right"]84.04633[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61241[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:14 AM[/TD]
[TD="align: right"]84.10126[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.6078[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:20 AM[/TD]
[TD="align: right"]84.13152[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60626[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:25 AM[/TD]
[TD="align: right"]84.13707[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60626[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:30 AM[/TD]
[TD="align: right"]84.08121[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60063[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:35 AM[/TD]
[TD="align: right"]83.97731[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60012[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:40 AM[/TD]
[TD="align: right"]83.95341[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.59397[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:45 AM[/TD]
[TD="align: right"]83.63466[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.58731[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:50 AM[/TD]
[TD="align: right"]83.52306[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.58015[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:05:55 AM[/TD]
[TD="align: right"]83.17549[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.57299[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]11:06:00 AM[/TD]
[TD="align: right"]83.24986[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.56736[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]

etc... to row 116236
 
Upvote 0
Give this macro a try...
Code: 
Sub KeepFirstMinutesOnly()
  Dim LastRow As Long
  LastRow = Cells(Rows.Count, "A").End(xlUp).Row
  Range("A3:A" & LastRow) = Evaluate("IF(TEXT(A3:A" & LastRow & _
                            ",""mm/dd/yyyy hh:mm"")=TEXT(A2:A" & LastRow - 1 & _
                            ",""mm/dd/yyyy hh:mm""),"""",A3:A" & LastRow & ")")
  Range("A3:A" & LastRow).SpecialCells(xlBlanks).EntireRow.Select
End Sub
 
Upvote 0
whoohoo i got this

[TABLE="width: 488"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD="align: left"]Time[/TD]
[TD="align: left"]dwatt2[/TD]
[TD="align: left"]L33TUC_FLT[/TD]
[TD="align: left"]l33tuc[/TD]
[TD="align: left"]DF[/TD]
[TD="align: left"]l20fa1x[/TD]
[TD="align: left"]hftout[/TD]
[/TR]
[TR]
[TD="align: right"]04:13.0[/TD]
[TD="align: right"]83.25909[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61958[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]82.9603[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61548[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.01331[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.62573[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.51387[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.63137[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.92419[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.62368[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.75002[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61958[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.42615[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61856[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.07156[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61958[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.23187[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61907[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.15089[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61138[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]05:04.2[/TD]
[TD="align: right"]83.75203[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60934[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.04633[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61241[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.10126[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.6078[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.13152[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60626[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.13707[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60626[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.08121[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60063[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.97731[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60012[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.95341[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.59397[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.63466[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.58731[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.52306[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.58015[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.17549[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.57299[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]06:00.5[/TD]
[TD="align: right"]83.24986[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.56736[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.37943[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.56276[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.77675[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.55816[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.04648[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.551[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.77617[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.54743[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.11128[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.54589[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]84.24783[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.54232[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]83.89067[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.53925[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]82.85901[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.53619[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]81.90646[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.527[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]81.53456[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.52444[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]81.40382[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.52036[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]07:01.9[/TD]
[TD="align: right"]81.60603[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.52342[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]

its good but i want delete rows not empty rows
 
Upvote 0
So you went from having a date with hours minutes to telling us your times had seconds to what now looks like time only (no date) with decimal minutes. I'm going to sleep now, so I don't have time to test or modify my macro (although I think it should be close)... I check back when I get up and see if your question is still open or not.
 
Upvote 0
thank you sir

now i have this below data:-

[TABLE="width: 517"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD="align: right"]6/9/2014 11:04 AM[/TD]
[TD="align: right"]83.25909[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.61958[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:05 AM[/TD]
[TD="align: right"]83.75203[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.60934[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:06 AM[/TD]
[TD="align: right"]83.24986[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.56736[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:07 AM[/TD]
[TD="align: right"]81.60603[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.52342[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:08 AM[/TD]
[TD="align: right"]80.89255[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.50097[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:09 AM[/TD]
[TD="align: right"]82.85008[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.45663[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:10 AM[/TD]
[TD="align: right"]83.65703[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.38697[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:11 AM[/TD]
[TD="align: right"]83.41196[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.40373[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:12 AM[/TD]
[TD="align: right"]81.49182[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.40831[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:13 AM[/TD]
[TD="align: right"]82.60677[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.39205[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:14 AM[/TD]
[TD="align: right"]82.19104[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.56174[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:15 AM[/TD]
[TD="align: right"]81.55426[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.55765[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:16 AM[/TD]
[TD="align: right"]83.80222[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.5643[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:17 AM[/TD]
[TD="align: right"]81.37714[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.57759[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:18 AM[/TD]
[TD="align: right"]82.50862[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.55765[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:19 AM[/TD]
[TD="align: right"]81.1102[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.52904[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:20 AM[/TD]
[TD="align: right"]83.64943[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.53772[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:21 AM[/TD]
[TD="align: right"]83.55089[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.5224[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:22 AM[/TD]
[TD="align: right"]82.44308[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.51525[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:23 AM[/TD]
[TD="align: right"]80.98123[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.51219[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:24 AM[/TD]
[TD="align: right"]82.01205[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.49434[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:25 AM[/TD]
[TD="align: right"]81.75157[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.48567[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:26 AM[/TD]
[TD="align: right"]82.40268[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.44594[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:27 AM[/TD]
[TD="align: right"]81.54965[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.42406[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:28 AM[/TD]
[TD="align: right"]81.64493[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.39611[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:29 AM[/TD]
[TD="align: right"]80.73634[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.32915[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]6/9/2014 11:30 AM[/TD]
[TD="align: right"]79.99791[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]50.30181[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]

I want to delete rows every 10 m to be like below :-
[TABLE="width: 517"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 529"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Time[/TD]
[TD]dwatt2[/TD]
[TD]L33TUC_FLT[/TD]
[TD]l33tuc[/TD]
[TD]DF[/TD]
[TD]l20fa1x[/TD]
[TD]hftout[/TD]
[/TR]
[TR]
[TD]6/9/2014 11:10 AM[/TD]
[TD]83.65703[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]50.38697[/TD]
[TD]0[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]6/9/2014 11:20 AM[/TD]
[TD]83.64943[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]50.53772[/TD]
[TD]0[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]6/9/2014 11:30 AM[/TD]
[TD]79.99791[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]50.30181[/TD]
[TD]0[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
alimadhi said:
I want to delete rows every 10 m to be like below :-
[TABLE="width: 517"]
<tbody>[TR]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 529"]
<tbody>[TR]
[TD]Time[/TD]
[TD]dwatt2[/TD]
[TD]L33TUC_FLT[/TD]
[TD]l33tuc[/TD]
[TD]DF[/TD]
[TD]l20fa1x[/TD]
[TD]hftout[/TD]
[/TR]
[TR]
[TD]6/9/2014 11:10 AM[/TD]
[TD]83.65703[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]50.38697[/TD]
[TD]0[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]6/9/2014 11:20 AM[/TD]
[TD]83.64943[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]50.53772[/TD]
[TD]0[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]6/9/2014 [/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...
(I couldn't sleep) give this macro a try...
Code: 
 Sub KeepEveryTenMinutes()
  Dim LastRow As Long, UnusedColumn As Long
  LastRow = Cells(Rows.Count, "A").End(xlUp).Row
  UnusedColumn = Cells.Find("*", , xlFormulas, , xlByColumns, xlPrevious).Column + 1
  With Cells(2, UnusedColumn).Resize(LastRow - 1)
    .Formula = "=IF(MROUND(A2,TIME(0,10,0))=A2,A2,"""")"
    .Value = .Value
    .SpecialCells(xlBlanks).EntireRow.Delete
    .Clear
  End With
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
Converting Time Start/Stop Ranges to Presence/Absence
Replies
6
Views
244
myall_blues
myall_blues
E
  • Question Question
Pulling together data from multiple MS Forms spreadsheets and displaying into a single league table
Replies
6
Views
253
excelnewbie999
E
M
  • Question Question
SLA Time Calculation
Replies
5
Views
254
felixstraube
F
M
  • Question Question
Pivot table not showing as Numbers
Replies
1
Views
235
shift-del
shift-del
K
  • Question Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
567
awoohaw
awoohaw

Forum statistics

Threads
1,222,102
Messages
6,163,940
Members
451,866
Latest member
cradd64

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top