Strip out seconds from dd/mm/yyyy hh:mm:ss

[Jameo]

Hi all,

As the topic title suggests I am trying to strip out the seconds from my time stamps, so:

17/04/2011 06:15:32

Would become:

17/04/2011 06:15:00

Thanks in advance all

 

[VoG]

Try

=FLOOR(A1,1/1440)

 

[Jameo]

Excellent stuff yet again Peter.

Many thanks