changing time format when concatenating

  • Thread starter Thread starter stewdawg35
  • Start date Start date
S

stewdawg35

I am trying to combine several columns of data with the concatenat
function. One of the columns is a time amount in minutes and seconds
but is being interpreted as hours and minutes, i.e. 4:23 is interprete
as 4:23 AM. When I concatenate this column the 4:23 turns int
something like .16777777783.

I have tried to change the format of the column but it does not seem t
want to work.

How can I change my data to a text format so that when it concatenate
it does not change from 4:23 to .16777777783 etc.

Thank you

Stewar
 
Hi

this should work

=A1&" "&B1&" "&TEXT(C1,"h:mm")
where C1 has the time in it

Cheers
JulieD
 
Back
Top