Thread
:
Time Calculation Question
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Time Calculation Question
=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?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann