# Sort 101(Time Stamp) Field

#### tbpowers

##### Board Regular
A colleague sent me a spreadsheet that contains a Time Stamp field and asked that I filter it by seconds. He wants the time sorted to show records where the seconds = :00. Any idea how I could accomplish this?

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
How does the data appear in the SS?

lenze

try this

Insert a column to the right of your time stamp

Say time is in column A use the formula

=SECOND(A1)=0

Then filter on this column for TRUE

or just
=SECOND(A1)

and filter for zero

In the SS it appears as "9:32:57". If you click on the cell it shows at the top as "3/26/2009 9:32:57 AM".

=SECOND(A1)=0

Worked like a charm. Thanks.

Replies
1
Views
873
Replies
14
Views
2K
Replies
0
Views
509
Replies
2
Views
411
Replies
1
Views
372

1,196,474
Messages
6,015,432
Members
441,894
Latest member
Zululander

### 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.

### Which adblocker are you using?

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

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