View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 363
Default Please help with formating

I have a column that has times written as numbers, so, I have 1:30 written as
1.3 and 24:00 written as 24. and so on. When I try to format the column as
Time, I get very strange results. I need to format the time so that it would
go from 0:00 to 24:00 (military hours). I have so many records to go manually
to make these changes. When I make the change manually it works fine. Can
someone help me please. I am trying to meet a deadline and this way, it will
take forever.
thanks
Al