desnyder2001
New Member
- Joined
- Aug 4, 2017
- Messages
- 12
So please be kind, I am a rookie and don't understand a lot of the language people use when responding to my questions.
1. I have a spreadsheet and I DON'T want to reconfigure the whole thing so I am hoping to get an answer to what I hope is a simple question.
2. I am using a customer format for time [h]:mm
3. The spreadsheet is a timesheet.
In cell O7 I sum up 7 days M-F of time totals (= E9+F9+G9+H9+I9+J9+K9)
I only what cell O7 to show any regular hours (40 hours or less)
In cell P7 I would like to display the Overtime Hours / Just the number of hours that are greater than 40.
I seems like it should be simple, but it is NOT Help Please



1. I have a spreadsheet and I DON'T want to reconfigure the whole thing so I am hoping to get an answer to what I hope is a simple question.
2. I am using a customer format for time [h]:mm
3. The spreadsheet is a timesheet.
In cell O7 I sum up 7 days M-F of time totals (= E9+F9+G9+H9+I9+J9+K9)
I only what cell O7 to show any regular hours (40 hours or less)
In cell P7 I would like to display the Overtime Hours / Just the number of hours that are greater than 40.
I seems like it should be simple, but it is NOT Help Please


