| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Remove time from a date and time field? Format removes the displa.
How do I remove time from a date and time field? Format removes the display
but I need to filter to just show unique based on the day. Since the time is part of the field, I am not able to receive the filtering by day. |
|
#2
|
|||
|
|||
|
=INT(A1)
-- HTH RP (remove nothere from the email address if mailing direct) "oaoboc" wrote in message ... How do I remove time from a date and time field? Format removes the display but I need to filter to just show unique based on the day. Since the time is part of the field, I am not able to receive the filtering by day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Linear Mode
