Excel Date Conversion

Soldato
Joined
8 Mar 2005
Posts
3,933
Location
London, UK
Probably a very simplistic one for the Excel crowd but I need to convert the following time/date field in order when the data is pivotted I'm able to present by Month and also by week.

06/05/2011 06:14:51 (this is a resolution detail, where the time aspect can be dropped)

Thanks in advance!

Cheers, Paul.

EDIT -
Bodged it with LEFT and DATEVALUE and then Grouping. Wood for trees moment.
 
Last edited:
Back
Top Bottom