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 ?
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" <[email protected]> wrote in message news:[email protected]...
| 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks