Convert time to text
 

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

Convert time to text
 

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

Convert time to text
 

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

Convert time to text
 

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

Convert time to text
 

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

Convert time to text
 

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