read only numbers from mixed cells in excel
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
i want to read the following coloum:
9:28:53.321 AM
9:28:53.421 AM
9:28:53.521 AM
but without the AM. thanks
0 Kommentare
Antworten (1)
Star Strider
am 13 Mai 2017
Read it with the ‘AM’ and ‘PM’, then use the datenum or datetime functions to make the appropriate time-of-day conversions to 24-hour time.
Please never discard useful information!
2 Kommentare
Star Strider
am 13 Mai 2017
You can get them in the same format by first using the ‘AM’ and ‘PM’ to be certain the times get imported and converted correctly. You can then use whatever format you want for the output. For ‘AM’ times, the hours will be unchanged, for ‘PM’ times, 1 PM will become 13, for example.
There are many possible output formats from the date and time functions. You do not need to specify ‘AM’ and ‘PM’ in the output unless you want to.
Siehe auch
Kategorien
Mehr zu Dates and Time finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!