time format

[Eleanor van der Hoest]

Cell format for time is set at hh:mm but cell reference
shows hh:mm:ss. It must be in hh:mm format to export to
another system. Any ideas how to remove the seconds part
of the format or convert to text format without having to
retype all entries?

 

[Jason Morin]

You could round to the nearest minute with:

=ROUND(A1/(1/24/60),0)*(1/24/60)

and then copy the formula down. Now copy this and paste
special > value over column A and reformat as hh:mm.

HTH
Jason
Atlanta, GA

 

[jeff]

Hi,

Select a cell, then menu: format>cells>time; select
the 13:30 style. the seconds should be gone. now
select the format copy brush icon and select-and-drag
down all your other times.

jeff