converting numbers to Time Range

Discussion in 'Microsoft Excel Worksheet Functions' started by Mediaexcel, Apr 29, 2004.

  1. Mediaexcel

    Mediaexcel Guest

    Hello,

    I have two columns with start and end times, however these wer
    imported from a pdf file and are not in TIME format. I need to inser
    the third column with the time block value, which could be a 30min or
    hr. I also have a column with the exact time.

    I use the time block values in a formula later in a SUMPRODUCT functio
    i.e. ($H$4:$H$457="6-6:30PM")

    Any suggestions?

    S

    Attachment filename: time block example.xls
    Download attachment: http://www.excelforum.com/attachment.php?postid=52889
    --
     
    Mediaexcel, Apr 29, 2004
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    Converting Numbers to Time

    Guest, Jul 15, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    6
    Views:
    523
    Peo Sjoblom
    Jul 15, 2003
  2. Guest

    Converting Numbers to Time

    Guest, Feb 18, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    201
    Ron Rosenfeld
    Feb 19, 2005
  3. Guest

    How to add the 10 smallest numbers out of a range of 20 numbers.

    Guest, Jul 9, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    337
    Guest
    Jul 10, 2005
  4. Guest

    Converting positive numbers to negative numbers

    Guest, Jul 17, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    487
    Bondi
    Jul 17, 2006
  5. Guest

    Excel Addin:Setting the range to the Excel.Range object range prop

    Guest, Nov 17, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    765
    jlepack
    Nov 24, 2006
  6. Guest

    How to select top six numbers from a of range of random numbers

    Guest, Jan 30, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    322
    Guest
    Jan 30, 2007
  7. Guest

    numbers within a range of numbers

    Guest, Apr 21, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    13
    Views:
    334
    T. Valko
    Feb 11, 2008
  8. Converting Time to decimals and then converting decimals to time

    , Nov 30, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    651
    Pete_UK
    Nov 30, 2007
Loading...