Thread
:
Formulas Not Calculating Correctly
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Daren
external usenet poster
Posts: 162
Formulas Not Calculating Correctly
Yes
"Sandy Mann" wrote:
Do the copied A1 & B1 cell in the new sheet contain 9:00 & 12:00?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Daren" wrote in message
...
Here is more information...The data are times. For example, cell A1 is
9:00
and cell B1 is 12:00. Cell
C1 contains the formula B1-A1, and this is where the calcuation is not
right...instead of returning 3 hours, it would return something like 1
hour.
Also, cell D1 is a convert function for converting hours to minutes, and
the
formula is =convert(c1,"hr","mn). Therefore, the subtraction and convert
formulas are not working for this worksheet, even though they do work
properly for other worksheets in the file.
Thanks.
"Sandy Mann" wrote:
What does:
previous worksheets, the formulas in the new worksheet are not working
correctly.
mean?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Daren" wrote in message
...
In a new worksheet into which I have copied formulas & number formats
from
previous worksheets, the formulas in the new worksheet are not working
correctly. The formulas are for subtraction in one and conversions in
the
other column. How can this be fixed?
Reply With Quote
Daren
View Public Profile
Find all posts by Daren