How can you strip the time of day out of a date field

[Guest]

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 ?

 

[Guest]

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

 

[Niek Otten]

=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

| 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]

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

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

(Format as time)