date & time format

  1. W

    Date Format

    I am scraping data from a flight planning website that brings a date value into a cell like this: "Tue. 7/26". Currently I have the formula "=RIGHT(X42,2)" to extract the day and "=MID(X42,6,1)" to extract the month. This formula doesn't work all of the time depending on whether or not the...
    • wid2001
    • Thread
    • date & time format excel date calculations vba vba & excel
    • Replies: 2
    • Forum: Excel Questions
  2. A

    Consolidating Multiple Date formats into one

    Hi, I have a database which cannot be changed. When I extract all the data out there are several fields in date format. However over the time it has been populated into about 5 different date formats from DD/MM/YY to MM/DD/YY to the aforementioned with the time after it etc etc. I was...
    • ardykav
    • Thread
    • date & time format date and time format date code.
    • Replies: 9
    • Forum: Excel Questions
  3. J

    Edit Cell Contents using SendKeys?

    Good morning - I have a column of data containing dates that are entered as mm-ddd-yy. I have attempted to convert the format to mm/dd/yyy, but it appears the cell contents are being treated as text, and won't convert properly because Excel doesn't know if the year should be 19XX or 20XX...
  4. J

    Adding Space between number and converting the field into Date/Time

    Hello Guys I've tried and tried ... Searched and searched but couldn't find a solution.. So asking here to the experts... <tbody> A B 2016-02-2413:40:31 2/24/16 1:40 PM 2016-02-2413:36:05 <tbody> 2/24/16 1:36 PM </tbody> 2016-02-2413:40:08 2/24/16 1:40 PM 2016-02-2413:40:09...
    • justujoo
    • Thread
    • convert data date & time format space added space formula
    • Replies: 5
    • Forum: Excel Questions
  5. M

    Please Help This Armature. Question Regarding Date Formatting.

    Hi All, Apologies if this question is about I did search but could not find anything that could help me. First off I am new to the forums and after taking a brief look, it seems to be a great place to get excel knowledge/tips. Explanation/Question: I have a fairly large data extract I do...
    • MilsAlex
    • Thread
    • date date & time format date and text format date and time format vlookup
    • Replies: 4
    • Forum: Excel Questions
  6. M

    Power Query - Error in date data from password protected workbooks

    When I create a query using Power Query (Excel 2016) and try to pull data from a table from a password protected workbook (already opened) there is always an error in the date column (whith any date format data) and plain numbers appear instead of the date in the outcome. I've tried this with...
  7. M

    how to split "date@time" format. Please help

    Hello, I have in column C a long list of date and time in the following format: <tbody> 01/05@0558 </tbody> Where 01/05 is the date and 0558 are the 5:58 AM How can I split the format in two different columns and with the correct date (mm/dd/yyyy) and time (hh:mm) notation? Thank you so...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top