| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert date/time formats differently?
Hi folks. Whenever I pull data from my work dat server, I will get a
date/time data in this yyyymmdd hhmmss format. If the some times I get the date/time data in yyyymmdd mmss, signifiying that the ommitted hh is 00. how do I change the date/time format into something simpler, so that I can calculate the time difference in terms of hh:mm:ss ? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to easily convert US to UK date formats? | Excel Worksheet Functions | |||
| What exactly does the asterisk mean in the Date/Time formats? | Excel Discussion (Misc queries) | |||
| formulas using date/time formats returning #value | Excel Discussion (Misc queries) | |||
| Multiple Date/Time Formats | Excel Worksheet Functions | |||
| US vs UK date and time formats | Excel Discussion (Misc queries) | |||
Threaded Mode
