Convert time to text

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

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
 
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
 
It worked, thank you so much!
Jacqueline

T. Valko said:
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
Click to expand...
 
This did not work, however here was the answer:
=IF(M34=TIME(0,1,0),"ARR",M34)
Thanks for the help
 
Back
Top