Ta ke a look at http://www.cpearson.com/excel/overtime.htm for an idea on how to organise a Timesheet record.
The only way I know how to do a rounddown function is through a function, which means it would call the information from a specific cell.
=ROUNDDOWN(A1,0) would look to cell a1 and round the number down to the nearest whole number, so 1.5 becomes 1, and 2.5 becomes 2, etc.
You can do these calculations elsewhere on the sheet, and then display the totals nearby, but you would need to have someone who was better in vb to be able to write you a code that would automatically change the values in the cells, after you input them.
hang around till someone more knowledgeable in VB comes around.
The only way I know how to do a rounddown function is through a function, which means it would call the information from a specific cell.
=ROUNDDOWN(A1,0) would look to cell a1 and round the number down to the nearest whole number, so 1.5 becomes 1, and 2.5 becomes 2, etc.
You can do these calculations elsewhere on the sheet, and then display the totals nearby, but you would need to have someone who was better in vb to be able to write you a code that would automatically change the values in the cells, after you input them.
hang around till someone more knowledgeable in VB comes around.
