1. E

    Convert number into hours in minutes

    example In Time 8:00 AM --A Out Time 3:00 PM --B formula 24*-(A-B) Answer 7.00 how do I convert this number into hours and minutes.
  2. B

    Punctuate text in MS-Excel

    Hello, I have a thousands of columns of quotations in MS-Excel. I would like to punctuate them. Is there a formula I can use to do it? For Example: I would like to change: abc to "abc". Thanks in advance.
  3. D


    I am creating an MS-Excel sheet, with hyperlinks, which would point to other MS-Excel Workbooks, in various network, locations/file folders. How do I create a hyperlink, using Insert, pointing to an MS-Excel Workbook, Sheet10, Cell M100. (As an example, and the file is located in a network...
  4. J

    addition with conditions without using macro.values are dynamic.

    A B C D E F G <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> 1 a 200 a:10 b:20 c:30 d:40 2 b 500 a:10 b:20 c:30 d:40 3 c 1000 a:10 b:20...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...