It worked, thank you so much!
Jacqueline

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"Jacqueline" wrote in message
...
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