| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting time for m:ss.00 | Excel Discussion (Misc queries) | |||
| Time Formatting | Excel Discussion (Misc queries) | |||
| Time formatting | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
