time format from serial to decimal

September 10, 2010 at 04:03:25
Specs: Windows XP
I am trying to amend a colum of time formats that appear showing as Hour/Minute/Seconds I have tried to filter the information using the filter option on excel but it does not reconise the time when filtering using a range (Greater than or equal to) - (Less than or equal to). I have been told that the format can be changed but do not seem to find how to do this. I have tried amending the format to no avail. please help.

See More: time format from serial to decimal

Report •

#1
September 10, 2010 at 04:49:09
I'm not sure what you mean by "does not reconise the time when filtering using a range (Greater than or equal to)".

With my data and criteria in Column A, I got the following results in Column B. Is that not what you would expect?


   A             B
Time    
=">=4:45:31"   
    
Time           Time
4:30:22       5:30:45
5:30:45       6:30:01
6:30:0        7:45:11
7:45:11       4:45:32
4:45:32    


Report •
Related Solutions


Ask Question