Excel Day
That is, you worked hours for Excel. Now, it multiplies this value for the value of its hour of wage and the result is not R$ 250. When formatting for hours, you it will get 00:59: 59 (1 hour). Again, the reason for such ‘ ‘ discrepancy’ ‘ it is that 25 hours in the day do not exist the such. In this in case that, 25 hours represent 1 hour of the morning of the following day (24 hours of the previous day + 1 hour of the new day). This is probably one of the first problems that any person who already has worked with hours in Excel finds.
To be just with Excel, this is not a problem, but the lack of understanding of as Excel manipulates dates and hours. Therefore, in the previous example you need to convert the values for the correct base (24 for hours), that is, 1,04165509259259*10*24 you return R$ 250 as the value to be paid for the worked hours. Of the example above, we can take off some conclusions. First that ‘ ‘ 24 horas’ ‘ they are represented by whole number 1. Any hour inside of one day is represented by the fraction hora/24 e, consequential, the minute is represented by minuto/1.440 and as by Segundo/86.400. Thus being, the decimal houses represent the combination of hours, minutes and seconds inside of one day (24 hours). If to divide the day in four parts, we have 6 hours or of the day. The table below shows to the fractionate value for these four parts: Corresponding hours of the day and fractions Hour Fraction 00:00: 00 0,00 00:06: 00 0,25 00:12: 00 0,50 00:18: 00 the 0,75 increment is of for each one of the values. To the end 24-hour, we have 1 day (24/24). It observes that these are the decimals and if you to format value 2,75, for example, for hours the total will be of 18 hours.