I am Calculating Over Time of the employees in time format cell using **Microsoft Excel 2007**. In my result, its calculated as hh and mm. But I want only Hours and ignore Min. 

Eg : I have to get this result of SANIA SARWER **0.18** as **0.0**

See the screenshot below.

[![Here is my Screenshot](https://i.stack.imgur.com/2gMy2.png)](https://i.stack.imgur.com/2gMy2.png)
['https://Stackoverflow.com/questions/50041497', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/5945772/']
```
=SUMPRODUCT(Int(24*$B:$B),--($A:$A=D2))

```

How does it work?
-----------------

Well, `SUMPRODUCT` will go through each item and multiply them together (So `SUMPRODUCT(A1:A3,B1:B3)` is the same as `=(A1*B1)+(A2*B2)+(A3*B3)`) - now, let's looks at each of the columns we're multiplying. 

`INT(24*$B:$B)` is just Days, converted to Hours, and trim off the decimal part (minutes/seconds) - fairly simple. 

`--($A:$A=D2)` first checks if the value in column A is the same as in `D2` and gives `TRUE` or `FALSE`. The `--` then converts this into `1` or `0`, which we multiply by the hours before adding them all up.
Easiest way would be to **Round Down** the data using ROUND function, and then use SUM function to add the rounding data up.

You can find a simple example below.

[![enter image description here](https://i.stack.imgur.com/EFvG9.png)](https://i.stack.imgur.com/EFvG9.png)