Remove time from date time
Hi,
Does anyone know how i can remove the time value from a cell whose data is date time. I need to do this to perform some calculation and not just for formatting so the Selection.NumberFormat = "dd-mmm-yy" will no work. Thanks in advance Prem |
Remove time from date time
Prem,
Dates & Times are stored as follows- Dates are whole integers stored as "Days-Since-1900", Times are stored as fractions of a day e.g. 0.5 is 12 midday. To get just the Date portion use the formula- =INT(A2) which strips off the Time portion. regards, JohnI "Prem Chandiramani" wrote in message om... Hi, Does anyone know how i can remove the time value from a cell whose data is date time. I need to do this to perform some calculation and not just for formatting so the Selection.NumberFormat = "dd-mmm-yy" will no work. Thanks in advance Prem |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com