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
    --
    Message posted from http://www.ExcelForum.com
     
    Mediaexcel, Apr 29, 2004
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Converting Numbers to Time

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

    Converting Numbers to Time

    Guest, Feb 18, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    133
    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:
    146
    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:
    278
    Bondi
    Jul 17, 2006
  5. Converting Time to decimals and then converting decimals to time

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

Share This Page