Printable View
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
is the cell still formatted as a time/date field?
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
use 3 cells for time, h,m,s
timeserial(A1,B1,C1)
how will i seggregate it.. i tried the left right functions...no help as it does not recognize the 0's...
3 cells are already separate. you put them together with timeserial in a fourth cell. you format them back into hours, minutes, and seconds.
no good...i 'm getting data in time format only
VB Code:
that did the trick...thanks