Annuler l'arrondi d'un montant

%3CLINGO-SUB%20id%3D%22lingo-sub-2219241%22%20slang%3D%22fr-FR%22%3ECancel%20the%20rounding%20of%20an%20amount%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2219241%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20calculate%20an%20amount%20to%20be%20paid%20from%20hours%20in%20decimals%2C%20but%20when%20I%20multiply%20the%20cells%20decimal%20hours%20(7.42)%20by%20the%20cell%20hourly%20rate%20(18)%20I%20find%20myself%20with%20a%20rounded%20amount%20of%20133.50%20instead%20of%20133.56.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20cancel%20that%3F%3CBR%20%2F%3E%3CBR%20%2F%3ECounting%20on%20your%20expertise!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2219241%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2219344%22%20slang%3D%22en-US%22%3ERe%3A%20Annuler%20l'arrondi%20d'un%20montant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2219344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1001104%22%20target%3D%22_blank%22%3E%40apoleya%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20this%20is%20a%20rounding%20issue%20and%20assume%20that%207.42%20actually%20relates%20to%207%20hours%20and%2025%20minutes%2C%20which%20actually%20equals%207.416666666667.%20Multiply%20that%20by%2018%20and%20you%20get%20133.50.%3C%2FP%3E%3CP%3E7.42%20hours%20represents%207%20hours%2C%2025%20minutes%20and%2012%20seconds.%20Is%20that%20really%20what%20you%20want%20to%20be%20the%20basis%20for%20your%20calculation%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour à tous,

 

Je dois calculer un montant à payer à partir d'heures en décimales, mais lorsque je procède à la multiplication des cellules heures décimales (7.42) par la cellule taux horaire (18) je me retrouve avec un montant arrondi de 133.50€ au lieu de 133.56€.

 

Comment faire pour annuler cela ?

Comptant sur votre expertise !  

2 Replies

@apoleya I suspect that this is a rounding issue and assume that 7.42 actually relates to 7 hours and 25 minutes, which actually equals 7.416666666667. Multiply that by 18 and you get 133.50.

7.42 hours represents 7 hours, 25 minutes and 12 seconds. Is that really what you want to be the basis for your calculation?

@Riny_van_Eekelen 

I agree.

To change the time in minutes to the nearest 1/100 of an hour one would need to round the time interval using in the (English locale) formula
= ROUND(hours, 2)