I'm trying to sort by the time of day. Because the date and time field are
part of the same number the worksheet sorts by date then time.
Any suggestions ?

if the date-time is in A1, then:
=MOD(A1,1) will return the time part
--
Gary's Student


"Ron" wrote:

I'm trying to sort by the time of day. Because the date and time field are
part of the same number the worksheet sorts by date then time.
Any suggestions ?

=MOD(A1,1), fill down as far as needed.
Select the column, Copy, Paste Special, check Values.
Now you can sort on that column

--
Kind regards,

Niek Otten

"Ron" wrote in message ...
| I'm trying to sort by the time of day. Because the date and time field are
| part of the same number the worksheet sorts by date then time.
| Any suggestions ?

If you really have date and time in a cell (say A1):

=a1-int(a1)
or
=mod(a1,1)

(Format as time)


Ron wrote:

I'm trying to sort by the time of day. Because the date and time field are
part of the same number the worksheet sorts by date then time.
Any suggestions ?

--

Dave Peterson