View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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?