Calculation with Excel hours are not very accurate

Asked

Viewed 228 times

4

I have a spreadsheet that calculates the hours a company car is used in a month.

each race is scheduled starting time and final time taking 30-minute intervals.

at the end of the month then I have a table with the hours used of each that are summed for a total.

The problem is that the way Excel calculates the hours, the final result ends up having a small difference of a few seconds even having all the round times.

So is there any way to make these calculations better? Because I need accurate because I use this result to make the collections of the respective departments.

excel
  • 1

    Welcome to [en.so]. Although I have explained very well it would be a good thing if you put at least part of your code here, because otherwise it becomes vague and difficult for us to help you. Enjoy and make a [tour] by the site and check out the guide of [Ask].

  • 4

    I use almost daily a spreadsheet for a "bank of hours" that makes totalization of everything I worked in the year. I have no accuracy problem. It’s probably a flaw in your formulas. As Math said, it would be interesting to post the code and/or formulas you used.

  • @Math,@utluiz I forgot to mention that I am using the hours in decimal number format because I had problems typing in time format (##:###). and as the conversion of decimal numbers to time is not exact ends up giving these differences.

  • 1

    makes the account in hand hour plus hour + entire part of the sum of minutes/60 plus sum of minutes module 60

  • Still, if you post your code (or, better yet, a simple and functional example of your problem) it will make it much easier for us to help you. :)

  • And, boy, did you solve your problem?

Show 1 more comment

1 answer

4

Dude, excel works excellently with hours, you might be working wrongly with excel.

Try formatting the fields as time, and fill in the field in the following HH:MM:SS format (11:56:32). Then just enter the formula of one minus the other

= A1 - B1

It will return you the exact value of time between one and the other, if this time can be greater than 24 hours, go to format and choose the option that displays at the time a value greater than 24, example:

Ctrl + Shift + F

then select the number tab, in the list click on time, then on the option (ex: 37:30:55)

Try to stick to that method and you won’t have a problem with hours

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.