| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove the date, leave the time | Excel Discussion (Misc queries) | |||
| Remove Time from Date | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Remove Time Element of a Date | Excel Worksheet Functions | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
