Formatting Time

  • Thread starter Thread starter Dan D...
  • Start date Start date
D

Dan D...

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
 
F9 will recalculate the sheet in Excel 2000. That may replace the F2
and enter operation.
 
Sounds like the source data are text numbers

Try this to convert it all at one go to real numbers:
Copy an empty cell, then select the data col, right-click > paste special >
check "Add" > OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
 
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 1600
your result will be 1640. ( I think my math is ok??) :0)
 
Meebers said:
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)
Click to expand...

corrected my example
 
Thanks, very good to know. I don't think it will effect me on this project,
but it might in the future.
 
Back
Top