Time Calculation Question
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? |
Time Calculation Question
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? |
Time Calculation Question
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? |
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? |
Time Calculation Question
=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? |
All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com