I column B I have a start time, in C an end time and in E I have the total
hours. At the end of the month I have a total for column E. If I enter 10:00
in B and 10:45 in C for 30 days, it says .8 for each of the 30 days in column
E which is what I want. The problem is at the end of the month it is not
adding all the .8's, it is adding 30 days * 45 minutes which is 22.5 rather
than 24.0.

Is there a formula that I can use to round this up or down.

Thanks