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?

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?

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?

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?