"Pam" <Pam@discussions.microsoft.com> wrote in message
news:9AD2FC4A-2C40-4F82-A504-84153F5C466C@microsoft.com...
> An automatically generated report has a column of dates/times in the
> format:
> mm/dd/yyyy hh:mm:ss AM
>
> We want to be able to sort this column ONLY by the times. We don't care
> about the date. When we change the format of the cells to contain only the
> time, the sort sorts by the entire date/time (because we never really
> changed
> the contents of the cells).
>
> So, basically what I want to do is 'strip out' the date information,
> leaving
> only the time information. Any ideas?

=MOD(A1,1)
--
David Biddulph