Calculating with Excel times are not very accurate

Navigation
4

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

Each race is marked start time and end time taking intervals of 30 minutes.

At the end of the month I then have a table with the used times of each that are summed to 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 though all the times are round.

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

    
asked by anonymous 07.11.2014 / 16:46

1 answer

4

Dude, excel works great with hours, you may be working wrong with excel.

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

= A1 - B1

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

Ctrl + Shift

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

Try to maintain this method and you will not have problems with hours

    
19.11.2014 / 14:31
Difference of StringBuffer.equals and String.equals in Java What is the best way to create a conditional foreign key constraint?