text to date conversion

  1. J

    Formula for lookup, sum if and date range

    I am looking for someone who is proficient in formulas to help me out. I am trying to match a date range and total sums if the row falls between the date range. I want to do this as a formula, not a macro. My file has three worksheets. In worksheet 'PT', column E (Line Description) lists the...
  2. C

    Text Time string to usable date.

    I use a program that totals equipment downtime and outputs the total downtime in the following format as text: 11h 14m 50s 1m 02s 39s Is there a way to turn this into an excel time format? Thanks!
  3. M

    Text Date format conversion

    I'm having problems with some date formats on a spreadsheet which I'm hoping you can help with. This spreadsheet is our company orderbook which is pulled from a central database and for some reason some of the dates come out as text format. I have a macro which formats the spreadsheet so that it...
  4. G

    text to date

    Hi All, I am extracting data from Ms-acess to Vba form on spreadsheet control. the spreadsheet shows date column in two formats, as -'dd/mm/yyyy (followed by (')) and mm/dd/yyyy. i have tried to change the format of date filed but it is not effective for 'dd/mm/yyyy formating and mm/dd/yyyy...

Watch MrExcel Video

This Week's Hot Topics

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
Top