| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to separate date and time formula
Hi
How do you create a formula to separate date 04/12/2007 and time 00:00:00? 4/12/2007 00:00:00 Thank you, Soth |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to separate date and time formula
If A1 contains your combined date and time, then...
For the date part: =INT(A1) For the time part: =MOD(A1,1) You will probably have to format the cells you put these formulas in to display the date and time properly. -- Rick (MVP - Excel) "Soth" wrote in message ... Hi How do you create a formula to separate date 04/12/2007 and time 00:00:00? 4/12/2007 00:00:00 Thank you, Soth |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to separate date and time formula
Wonderful - Thanks Rick "Rick Rothstein" wrote: If A1 contains your combined date and time, then... For the date part: =INT(A1) For the time part: =MOD(A1,1) You will probably have to format the cells you put these formulas in to display the date and time properly. -- Rick (MVP - Excel) "Soth" wrote in message ... Hi How do you create a formula to separate date 04/12/2007 and time 00:00:00? 4/12/2007 00:00:00 Thank you, Soth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Linear Mode
