Results 1 to 4 of 4

number.... text..... convert..... HEADACHE!

Threaded View

  1. #1
    Registered User
    Join Date
    06-16-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question number.... text..... convert..... HEADACHE!

    So, my problem is simple but for the life of me I cannot figure it out.

    I have a time in F2 12:35
    In G2 I want to display the first two digits of the time 12

    I tried =left(f2,2) but thats just for text

    I need to sort arrivals by hour and then give average length of stay based on arrival by hour...

    Any help would be greatly appreciated!

    TLS
    Last edited by romperstomper; 06-17-2011 at 09:06 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1