| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date and Time Conversion
I have a spreadsheet with the date in the first column in MM/DD/YYYY format
and the time in the second column in HH:MM format. Is there some way to convert that to a single date/time column in MM/DD/YYYY HH:MM format so I can use that column of date/times as the x-axis in a line graph (utility data)? How? (I'm using Excel 2000.) Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time conversion????? | Excel Discussion (Misc queries) | |||
| DATE AND TIME CONVERSION HELP | Excel Worksheet Functions | |||
| Date & Time Conversion from xml import | Excel Discussion (Misc queries) | |||
| Time Conversion | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Threaded Mode
