Time Calculations

[vanborte]

I've uploaded an example of a time sheet I've created for my small business. I've figured out how to get the formulas working that calculate the number of hours a person has worked on any given day, but I'm having difficulty getting the column to total for the week's hours. (the cell that is highlighted in yellow)

I'd like to add together the values found in column G and display the findings in a format that indicates the number of hours and minutes worked per week. I'd also like to know if it's possible to set formulas in the blue shaded cells that will calculate the number of hours over 40 and display that in the same format.

Currently, I'm doing these calculations manually and it's taking too long.

Any help would be greatly appreciated.

V

[Kevin UK]

Hi vanborte

That is text values in column G. see the attached. Column I.

[vanborte]

Thanks Kevin,
I take it then, that because I've displayed my G column in a text format I cannot total the column? I've used the text format so I can submit the document up my chain of command with an hour / minute format.
I'll rework the sheet to maybe use a hidden column to make the calculations.
Thanks again.
Richard