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

--
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

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

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

Try:

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


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122375

Hi
try

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

"Jacqueline" wrote:

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

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

"Eduardo" wrote:

Hi
try

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

"Jacqueline" wrote:

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