- #1
- 726
- 166
Hey everyone,
This may not be the right place to post this, so if an admin thinks a different section would be better suited, please move this thread.
So I'm in the midst of my summer internship at Fermilab right now. I'm currently trying to plot some data for the beam intensity of the NuMI neutrino beam line. I have long strings of dates of the form (day, month, date, clock time [to thousandths of a second]). For example:
##t_0##=Thu Jun 11 22:04:00.478 and ##t_{final}##=Thu Jun 11 23:03:59.142
When I plot this data in Excel it gets converted to numerical values ranging from 0 to ~2400. What I need to do is drop the day/month/date portion and convert my x-axis to showing values in clock time. Doing this manually isn't an option because I have upwards of 50,000 data points in some of these strings. The various formulas I've found for doing this don't really match up with the date format I have here, so I'm a bit lost.
Any help would be very appreciated!
This may not be the right place to post this, so if an admin thinks a different section would be better suited, please move this thread.
So I'm in the midst of my summer internship at Fermilab right now. I'm currently trying to plot some data for the beam intensity of the NuMI neutrino beam line. I have long strings of dates of the form (day, month, date, clock time [to thousandths of a second]). For example:
##t_0##=Thu Jun 11 22:04:00.478 and ##t_{final}##=Thu Jun 11 23:03:59.142
When I plot this data in Excel it gets converted to numerical values ranging from 0 to ~2400. What I need to do is drop the day/month/date portion and convert my x-axis to showing values in clock time. Doing this manually isn't an option because I have upwards of 50,000 data points in some of these strings. The various formulas I've found for doing this don't really match up with the date format I have here, so I'm a bit lost.
Any help would be very appreciated!