durations calculated from different start/end times multiplied with h rate and VAT differ

%3CLINGO-SUB%20id%3D%22lingo-sub-2309832%22%20slang%3D%22en-US%22%3Edurations%20calculated%20from%20different%20start%2Fend%20times%20multiplied%20with%20h%20rate%20and%20VAT%20differ%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309832%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20project%20time%20tracking%20the%20customer%20wants%20a%20simple%20table%20with%20one%20line%20per%20day.%3CBR%20%2F%3EDifferent%20start%2Fend%20times%20which%20result%20in%20the%20exact%20same%20duration%2C%20lead%20to%20a%20difference%20after%20being%20multiplied%20with%20the%20hourly%20rate%20and%20the%20customer-specific%20discount%2C%20resulting%20in%20a%20difference%20of%201%20cent%20when%20calulating%20VAT.%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20like%20to%20understand%20where%20the%20difference%20comes%20from.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2309832%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309873%22%20slang%3D%22en-US%22%3ERe%3A%20durations%20calculated%20from%20different%20start%2Fend%20times%20multiplied%20with%20h%20rate%20and%20VAT%20differ%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309873%22%20slang%3D%22en-US%22%3EUse%20Round%20formula%20with%203%20digits%20and%20reduce%20digit%20to%202%20through%20home%20tab%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309926%22%20slang%3D%22en-US%22%3ERe%3A%20durations%20calculated%20from%20different%20start%2Fend%20times%20multiplied%20with%20h%20rate%20and%20VAT%20differ%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309926%22%20slang%3D%22en-US%22%3EThanks%2C%20Safy84.%20Yes%2C%20that%20results%20in%20same%20values.%3CBR%20%2F%3E%3CBR%20%2F%3EUnfortunately%2C%20it%20does%20not%20explain%20the%20cause.%3C%2FLINGO-BODY%3E
New Contributor

For project time tracking the customer wants a simple table with one line per day.
Different start/end times which result in the exact same duration, lead to a difference after being multiplied with the hourly rate and the customer-specific discount, resulting in a difference of 1 cent when calulating VAT. 

Would like to understand where the difference comes from. 

Thanks in advance. 

3 Replies
Use Round formula with 3 digits and reduce digit to 2 through home tab
Thanks, Safy84. Yes, that results in same values.

Unfortunately, it does not explain the cause.