| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to add date and time to a single cell in MS Excel 2007
Hi,
Iam trying to add date column ( 01.03.2009) and time column (23:30:00) to a single cell to get the result as 2/28/2009 23:30 using the formula : =IF(A1<"",A1+B1,""), But its throwing an exception of #VALUE! Please help in this regard. Thanks, Anil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 file/properties to view created date/time how in 2007? | Excel Discussion (Misc queries) | |||
| Excel 2007 single cell selecting muliple cell | Excel Worksheet Functions | |||
| Static Date & Time in Footer - Excel 2007 | Excel Discussion (Misc queries) | |||
| Static Date & Time in Footer - Excel 2007 | Excel Discussion (Misc queries) | |||
| MS Excel 2007 highlights multiple cells when selecting single cell | Excel Discussion (Misc queries) | |||
Threaded Mode
