1. N

    Convert duration in text to HH:MM:SS format in excel

    I have an extract of data where the duration for an activity is listed as ## hour ## Minutes ## Seconds ex. 1 hour 22 minutes 29 seconds. Is there a way to convert this a time format so I can perform date math between two activities? Not all entries have hour, minutes and seconds. There are...
  2. J

    Convert HHMMSS to time in VBA?

    Hi, In a database our timevalues are stored like 94500 = 09:45:00 121755 = 12:17:55 58 = 00:00:58 What is the best way to convert these when pulling them via ODBC? Ideally in the SQL query but power query is an option also. Thanks
  3. A

    convert decimal input to real time vba code

    Hi I need a vba code that converts a decimal input to real time and does nothing if it's time. for example: 2.5 convert to 2:30 3.5 convert to 3:30 and if input is time do notting 2:30 convert to 2:30 3:30 convert to 3:30 . . .
  4. J

    Convert To Numbers from Text

    Hello Message Board: I am trying to convert a small data set from text to number ( AMOUNT Column) . I have tried several methods including text to columns , Fomulas like =VALUE(TRIM(a3)), Trim, etc and I cannot get rid of the trailing spaces to the right. I need a formula solution for this. I...
  5. B

    Convert Excel Formula To Access

    I am trying to convert an excel formula in access but don't have the knowledge to do so. Is there a way to convert this excel formula to run with my access query? This is what I am using in Excel. =IF(S2<1825,"< 5 Years Old",IF(AND(S2>1824),"> 5 Tears Old")). The Access database name is...
  6. U

    Convert Report number to Date and Time

    I am trying to convert this report number to a date and time, is there a single formula that can achieve this or do I need extract the numbers using left/right formula? W3_20190903_230338 = Sept.3,2019, 11:03:38 pm
  7. P

    Time to Number Convertion help.

    How to convert 13:10 (13 hrs. 10 mins) into 13.7 (number)?
  8. W

    VBA and urls

    I am using vba code to populate the body of an email. In this line [& "Invoicing with Mercury - " & vbLf _] How do I convert this [] into a url [link]?
  9. E

    Coverting layout of spreadsheet

    Hi there, I am completely new to excel and I was unaware of the extent of its functions. I have been tasked with converting the layout of a cinema timetable that is in a spreadsheet. the timetable also includes the age rating of the movie and the director . I am also not going to include certain...
  10. G

    Convert text to numbers?

    Hi, I have a worksheet where the data has come from an external database...The numbers have come through as text... e.g. '$123,444 How can I convert these to numbers...I've tried using formatting and that doesn't work. Thank you
  11. B

    Convert DAX Calculated Column to a Measure

    Trying to convert a DAX Calculated Column to a Measure with no luck. Any ideas? See below and attached. Thanks. =CALCULATE ( DISTINCTCOUNT ( Table1[Patient ID] ), FILTER ( Table1, Table1[TotalTime] > Legend[Start] && Table1[TotalTime] <= Legend[End] ) )...
  12. B

    how to convert to VBA - Weekending date

    im trying to create a code to get the weekending date. However, there is an error when i try to run it. =A1+(7-WEEKDAY(A1)) - this is the code i'd like to convert to vba WE.Value = transdate.Value + (8 - Weekday(transdate.Value)) -----****Note WE.value is a textbox where the weekending date...
  13. F

    Nbr in E Format Text want to Convert to Scientific Notation and Decimal Equivalent

    I have text in cells: A1 2.11667e-03 A2 2.01168e+02 A3 2.54e-02 I would cells B1,B2, and B3 to convert these text cells to their proper scientific notation. I would also like cells C1,C2, and C3 to convert these scientific notation numbers to their decimal equivalent. What...
  14. S

    Convert Worksheet Name to Date in a Cell

    Hi, I am attempting to automate some data entry in Excel. I have a workbook, and each sheet's name is a 6-digit date. I want to create a formula to add that sheet's name to a specific cell, but in a standard date format (m/dd/yyyy). For example, a sheet is named 083019. I want cell D2 to...
  15. R

    Formula bar value vs displayed cell value

    Good rainy afternoon. Perfect time for doing computer stuff. :) I export, in to excel, reports from a database. In one of my columns, (start time), the cell value displays as 0001 However, what shows in the formula bar, for that same cell, is: 7/12/2019 12:01:00 AM How do I get rid of the...
  16. F

    Convert text date to start and end date

    I would like to find an easy way to convert something like this (January 18 - February 2, 2019) stored in a single cell to start date and end date in separate cells. Here are a couple of examples: January 18 - February 2, 2019 February 6 - 19, 2019 Thanks
  17. Z

    Vba Convert Date value from 8/7/19 to August 7, 2019

    Hello All, Here is my situation, i'm using excel vba on a spreadsheet. All the values of column K are in mm/dd/yy ie (8/7/19). Now i have made a macro that take information from this sheets and fills a few word documents. My problem is that they now want the documents to display the full...
  18. D

    Distance between points - matrix

    Hey, i'm trying to make a table that looks like this: <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] B C D E F G </thead><tbody> 17 #FFFF00[/URL] , align: right"] #FFFF00[/URL] "]0 #FFFF00[/URL] "]5 #FFFF00[/URL] "]10 #FFFF00[/URL] "]15...
  19. danhendo888

    Convert PDFs into text?

    So we receive hundreds of invoices from our customers every day. The invoices are in pdf format but such that you can select the text and copy and paste etc Is there a way to convert multiple pdfs of invoices into data so that I can see it Excel or Word?
  20. D

    Convert ddmmyy to Qtr yy

    Afternoon Ppl, need some help here, how do i convert eg 25122019 (ddmmyyyy) or 251219 (ddmmyy) to show its Qtr4 19 ? Any solution to this ? Much thanks.

Some videos you may like

This Week's Hot Topics