Formatting Time

[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

 

[dan dungan]

F9 will recalculate the sheet in Excel 2000. That may replace the F2
and enter operation.

 

[Max]

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

 

[Meebers]

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]

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...]

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

 

[Dan D...]

It worked, thanks!

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

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik