Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent Formula Result
Hello,
I am using the TIME function in an existing workbook. I noticed it is calculating differently despite the same values. In column A, I have begin time. In column B I have the number of minutes it took to complete a process and in column C I have the summation of minutes and begin time to get the end time. I am using the function A1+TIME(0,B1,0) and the result is C1. Both A1 and B1 are also calculated fields. I don't believe that should matter. 18:00:00 1 18:01:00 18:00:00 1 18:00:00 Any explanation why Excel is providing different results? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent Formula Result
I figures it out. Sorry for the post. It was an issue with rounding numbers.
Once I added the round function, it works like a charm! Thanks. "Mike" wrote: Hello, I am using the TIME function in an existing workbook. I noticed it is calculating differently despite the same values. In column A, I have begin time. In column B I have the number of minutes it took to complete a process and in column C I have the summation of minutes and begin time to get the end time. I am using the function A1+TIME(0,B1,0) and the result is C1. Both A1 and B1 are also calculated fields. I don't believe that should matter. 18:00:00 1 18:01:00 18:00:00 1 18:00:00 Any explanation why Excel is providing different results? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent Formula Result
<I don't believe that should matter
It does, because rounding may occur Please post you formulas and input values -- Kind regards, Niek Otten Microsoft MVP - Excel "Mike" wrote in message ... Hello, I am using the TIME function in an existing workbook. I noticed it is calculating differently despite the same values. In column A, I have begin time. In column B I have the number of minutes it took to complete a process and in column C I have the summation of minutes and begin time to get the end time. I am using the function A1+TIME(0,B1,0) and the result is C1. Both A1 and B1 are also calculated fields. I don't believe that should matter. 18:00:00 1 18:01:00 18:00:00 1 18:00:00 Any explanation why Excel is providing different results? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent Formula Result
Input Value Examples
P2 = 14,000 J2 = 4 (My begin hour) T2 = TIME(J2+12,0,0) - converts my begin number to time format U2 = =IF(P216000,ROUND((P2/(P2+500))*30,0),ROUND(((P2/16000)*30),0)) P2 is a number less than or greater than 16,000. The formula above give me the number of minutes into the hour. V2 = =TIME(J2+12,0,0) W2 = =T2+TIME(0,U2,0) Adds my begin hour to the number of minutes to determine how long it took from the begin hour The result in "Niek Otten" wrote: <I don't believe that should matter It does, because rounding may occur Please post you formulas and input values -- Kind regards, Niek Otten Microsoft MVP - Excel "Mike" wrote in message ... Hello, I am using the TIME function in an existing workbook. I noticed it is calculating differently despite the same values. In column A, I have begin time. In column B I have the number of minutes it took to complete a process and in column C I have the summation of minutes and begin time to get the end time. I am using the function A1+TIME(0,B1,0) and the result is C1. Both A1 and B1 are also calculated fields. I don't believe that should matter. 18:00:00 1 18:01:00 18:00:00 1 18:00:00 Any explanation why Excel is providing different results? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA | Excel Discussion (Misc queries) | |||
Inconsistent Formula? | Excel Discussion (Misc queries) | |||
Strange and inconsistent result from a simple formula | Excel Worksheet Functions | |||
Inconsistent Formula | Excel Programming | |||
Formula results inconsistent. | Excel Worksheet Functions |