Thread: How can you strip the time of day out of a date field
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How can you strip the time of day out of a date field
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 ?
Reply With QuoteReply With Quote