CSV file Time won't remove seconds

[julesmctavish]

Hi;
I have to save my work reports from our software to CSVs.
The date stamp is shown as hour, minute, seconds.

I have tried using formatting, text formulas, and rounding and yet it still is displayed with seconds.
I just want minutes and seconds, but some of the research I have done says that CSVs are difficult to truncate to just seconds.

Thank you,

[Phuocam]

Use helper column:

=TEXT(A1,"[mm]:ss")

Or:

=TEXT(A1,"[hh]:mm")