-
Feb 8th, 2005, 09:51 PM
#1
Thread Starter
Addicted Member
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.
-
Feb 8th, 2005, 09:52 PM
#2
Re: Problem with date/time in excel
is the cell still formatted as a time/date field?
-
Feb 8th, 2005, 09:54 PM
#3
Thread Starter
Addicted Member
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
-
Feb 8th, 2005, 11:16 PM
#4
Re: Problem with date/time in excel
use 3 cells for time, h,m,s
timeserial(A1,B1,C1)
-
Feb 9th, 2005, 12:08 AM
#5
Thread Starter
Addicted Member
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...
-
Feb 9th, 2005, 12:31 AM
#6
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.
-
Feb 9th, 2005, 12:48 AM
#7
Thread Starter
Addicted Member
Re: Problem with date/time in excel
no good...i 'm getting data in time format only
-
Feb 9th, 2005, 01:36 AM
#8
Re: Problem with date/time in excel
-
Feb 9th, 2005, 10:24 PM
#9
Thread Starter
Addicted Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|