Back to Index

EXCEL 2010-2007 : HOW TO MULTIPLY HOURS BY A GIVEN HOURLY RATE

I need to multiply 40:00 by 30 CHF / hour
(hourly rate)

Here below what I get :

40 hours multiplied by 30 Swiss Frances / hour : the result is 50, which is incorrect

As for the tip about adding hours, the problem comes from the hour format.

Solution

Simply multiply the total by 24

multiplied by 24 and it is all OK

© Copyright : Office Doc / Web development by Office Doc