"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

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

"Meebers" wrote:


"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