Copy time as text

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

I have a column with a list of times, I want to use the times in a
equation and so need the times resembled as text.

Is there a fornula that can copy over the output date of a cell,

EG.

Col A

14:15 - as a time

Col B

14:15 - as tex
 
Hi Ian!

To do what you ask:

=TEXT(A1,"hh:mm")
TEXT returns text.

But what sort of equation are you doing where you want time as text
rather than as a number formatted as time?

Formulas and functions can only return values to cells. Perhaps you
might vary the entry in the cell that contains the date.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top