I think u have problem to sum of 30 days working houres. if it is :
1- Insert sum function for working days
2- If sum is not correct:
3- goto Format Cells, Number Page, Custom, in Type EditBox wite :
[h]:mm

"Kevin" wrote:

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