I am creating a report to reflect turnaround times:

the data is in the following format:

A B
C
1 3/14/2008 8:55:00 AM 3/18/2008 12:55:00 PM calculation

to calc the difference I have been just using B1-A1 and using general format
to get into days (this is repeated for many more columns to build a time line
so to speak)

the problem I am running into is not all the fields have values in them...

so when I run the formula I get a negative number that messes up averages
etc...

any recommendations?

What I would like to do is IF the cell is Blank Use colum "X" instead---

"Memphus01" wrote:

I am creating a report to reflect turnaround times:

the data is in the following format:

A B
C
1 3/14/2008 8:55:00 AM 3/18/2008 12:55:00 PM calculation

to calc the difference I have been just using B1-A1 and using general format
to get into days (this is repeated for many more columns to build a time line
so to speak)

the problem I am running into is not all the fields have values in them...

so when I run the formula I get a negative number that messes up averages
etc...

any recommendations?

nm - - I was having a slow brain day! :-)

"Memphus01" wrote:

What I would like to do is IF the cell is Blank Use colum "X" instead---

"Memphus01" wrote:

I am creating a report to reflect turnaround times:

the data is in the following format:

A B
C
1 3/14/2008 8:55:00 AM 3/18/2008 12:55:00 PM calculation

to calc the difference I have been just using B1-A1 and using general format
to get into days (this is repeated for many more columns to build a time line
so to speak)

the problem I am running into is not all the fields have values in them...

so when I run the formula I get a negative number that messes up averages
etc...

any recommendations?

=IF(COUNT(A1:B1)=2,B1-A1,"")

AVERAGE() will ignore the text ""

or if you must use Column "x"

=IF(COUNT(A1:B1)=2,B1-A1,X1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Memphus01" wrote in message
...
What I would like to do is IF the cell is Blank Use colum "X" instead---

"Memphus01" wrote:

I am creating a report to reflect turnaround times:

the data is in the following format:

A B
C
1 3/14/2008 8:55:00 AM 3/18/2008 12:55:00 PM
calculation

to calc the difference I have been just using B1-A1 and using general
format
to get into days (this is repeated for many more columns to build a time
line
so to speak)

the problem I am running into is not all the fields have values in
them...

so when I run the formula I get a negative number that messes up averages
etc...

any recommendations?

=IF(COUNT(A1,B1)=2,B1-A1,X1) or
=IF(OR(A1="",B1=""),X1,B1-A1)
--
David Biddulph

"Memphus01" wrote in message
...
What I would like to do is IF the cell is Blank Use colum "X" instead---

"Memphus01" wrote:

I am creating a report to reflect turnaround times:

the data is in the following format:

A B
C
1 3/14/2008 8:55:00 AM 3/18/2008 12:55:00 PM
calculation

to calc the difference I have been just using B1-A1 and using general
format
to get into days (this is repeated for many more columns to build a time
line
so to speak)

the problem I am running into is not all the fields have values in
them...

so when I run the formula I get a negative number that messes up averages
etc...

any recommendations?