Results 1 to 9 of 9

Thread: Problem with date/time in excel--Resolved

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Feb 2005
    Posts
    129

    Resolved Problem with date/time in excel--Resolved

    i have time in one cell. i just want the hour part of it..i formatted the cell to custom and changed it to "hh"..that gave me a great display but the actual value remains the same....for the time being i'm copying this formatted data to notepad and then copying the date back to excel to get only the absolute hour value..can anybody help
    Last edited by wussupbuddy; Feb 9th, 2005 at 10:24 PM.

  2. #2
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: Problem with date/time in excel

    is the cell still formatted as a time/date field?

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Feb 2005
    Posts
    129

    Re: Problem with date/time in excel

    i guess its not as it shows as custom with "hh" but the value in the cell as shown in the formula bar is still the old value

  4. #4
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: Problem with date/time in excel

    use 3 cells for time, h,m,s
    timeserial(A1,B1,C1)

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Feb 2005
    Posts
    129

    Re: Problem with date/time in excel

    how will i seggregate it.. i tried the left right functions...no help as it does not recognize the 0's...

  6. #6
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: Problem with date/time in excel

    3 cells are already separate. you put them together with timeserial in a fourth cell. you format them back into hours, minutes, and seconds.

  7. #7

    Thread Starter
    Addicted Member
    Join Date
    Feb 2005
    Posts
    129

    Re: Problem with date/time in excel

    no good...i 'm getting data in time format only

  8. #8
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: Problem with date/time in excel

    VB Code:
    1. format(mytime, "hh")

  9. #9

    Thread Starter
    Addicted Member
    Join Date
    Feb 2005
    Posts
    129

    Resolved Re: Problem with date/time in excel

    that did the trick...thanks

Posting Permissions

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



Click Here to Expand Forum to Full Width