| 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? |
| 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 | |||
Threaded Mode
