C
carolinakay
I need help with a timesheet formula. This timesheet is not done in the hour
format, but is done in the number format. I have a formula that works except
the result is not rounded. I need it to round to the next quater amount.
This is the fomula I am using.
A12+D12>40,D12+D12*.50,D12
Column A is total weekly/Column D is time earned/Column F is where I am
doing the formula and I need it to round off the totals I am getting from the
other columns.
For example:
40.00 worked 1.25 OVertime hours
format, but is done in the number format. I have a formula that works except
the result is not rounded. I need it to round to the next quater amount.
This is the fomula I am using.
A12+D12>40,D12+D12*.50,D12
Column A is total weekly/Column D is time earned/Column F is where I am
doing the formula and I need it to round off the totals I am getting from the
other columns.
For example:
40.00 worked 1.25 OVertime hours