Hello all,
I currently have a column beginning with 12:00:00, and would like values for each minute after instead of each second. Is there a way to delete/hide the other 59 seconds I do not need? Thanks in advance!
-YS
Hello all,
I currently have a column beginning with 12:00:00, and would like values for each minute after instead of each second. Is there a way to delete/hide the other 59 seconds I do not need? Thanks in advance!
-YS
Make new column with the formulaFormula:Please Login or Register to view this content.
Then use autofilter Equals 0
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
The easiest way to do this if the times are in a format recognized by Excel as time, is to use a Pivot table.
Make sure that there are headings for the time and the values columns (no blank columns between the data and no blank rows)
Click in the data, click on the Data Tab, click on Pivot Table.
A dialogue box with the fields will open. Drag the time field into the Row Labels and drag the values field in to the Values box. Right click in the column formed with the times and choose GROUP. Select MINUTES and click OK.
If the values field doesn't show the sum, then left click on the values in the Values box, click on Value Field Settings and choose Sum.
The data in the table should now show the data summarized by minute.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks