Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a CSV file with following syntax

7   11/11/2010 10.59.54 marty86ce   2.499
8   11/11/2010 10.59.57 marty86ce   2.533
9   11/11/2010 11.00.00 marty86ce   2.516
10  11/11/2010 11.00.03 marty86ce   2.508

I have to plot on the 5h column on the vertical axis (RTT in milliseconds from a network experiment) and the time, even approximate, of the measure on the horizontal axis.

I noticed that pasting the graph I produced so far into Word, and resizing it to make it smaller, shows only the date.

I would like to get the hour only from the second column to plot into the graph.

Can you help me? Thank you.

share|improve this question

1 Answer 1

up vote 0 down vote accepted
=MID(B1,FIND(" ",B1)+1,FIND(".",B1)-FIND(" ",B1)-1)

This uses the space after the date and the period after the hour to isolate that hour number.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.