change format

  1. B

    Time format

    Hi!! I get excel sheets which have departure time of the flights given in format like 1750 (I checked it says special format) can i convert this figure into 17:50 (A time format 17:50).It is important that the result is in time format as i use these values to create a histogram with flights...
  2. M

    Shorter VBA version to do the same thing?

    HI, I have the code I'm using now which works but was wondering if someone can help me condense it to do the same thing: THANKS! Sub Modify_Instr_Tab() Dim ws As Worksheet 'Assigns a due date to cell D10 Worksheets("Instructions").Range("D10").Select ActiveCell.Formula = "5/28/2010"...

Some videos you may like

This Week's Hot Topics