time format

  • Thread starter Eleanor van der Hoest
  • Start date
E

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?
 
J

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
 
J

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
 
Top