Thread: Formatting Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers Meebers is offline
external usenet poster
 
Posts: 80
Default Formatting Time


"Meebers" wrote in message
...
Just a thought.....1600 is sixteen hundred and is not 16 hours and 00
minutes. Also 1600 is base 10 and 16:00 is base 60. i.e. If you were to
add 00:40 to 16:30 your result will be 17:10, and if you add 0040 to 1630
your result will be 1670. ( I think my math is ok??) :0)


corrected my example

"Dan D..." wrote in message
...
I am having an issue with getting Excel to reformat time. I copy and paste
data from an Access query into a spreadsheet. After doing this, any
changes
to the formats on the sheet do not take effect unless I hit F2 and Enter.
These files are rather large, so hitting F2 then Enter is not ideal.

I'm trying to reformat time that is currently 24hour with colon (i.e.
16:00)
to 24 hour without colon (i.e. 1600 or 0500).

Does anyone happen to know why Excel isn't cooperating with me, or anyway
to
work around this?

Thank you for your time