Convert time to text

[Jacqueline]

I have data imported to Excel from a database. The database converts the
class time signatures that are set at ARR for arranged time to a time
signature of:

12:01:00 AM

I want to convert this back to ARR in the Excel spreadsheet. Here is the
formual I am using:
=IF(M34="12:01:00 AM","ARR",M34)
The result I get is:
12:01:00 AM

I am thinking that Excel does not reconize the time signature, but just
guessing. Any ideas?
Thanks much
Jacqueline

 

[T. Valko]

Try this:

=IF(M34=TIME(0,1,0),"ARR",M34)

The syntax for the TIME( ) function is TIME(hour,minute,second)

12:01:00 AM

Hour = 0
Minute = 1
Second = 0

 

[NBVC]

You need to coerce your text string (value in quotes) back to a numbe
(date)...

Try:

=IF(M34="12:01:00 AM"+0,"ARR",M34

 

[Eduardo]

Hi
try

=IF(M34="12:01:00 AM","ARR"&M34)

 

[Jacqueline]

It worked, thank you so much!
Jacqueline

Try this:

=IF(M34=TIME(0,1,0),"ARR",M34)

The syntax for the TIME( ) function is TIME(hour,minute,second)

12:01:00 AM

Hour = 0
Minute = 1
Second = 0

 

[Jacqueline]

This did not work, however here was the answer:
=IF(M34=TIME(0,1,0),"ARR",M34)
Thanks for the help