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 |
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 |
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 |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com