|
Re: excel question
easiest way to do this would be to count the non-blank cells,
taking B2 to contain the date & cells A2 to A25 contain the time in half hour slots.
enter the formula "=COUNTA(B2:B25)*0.5" into B26. This will count every cell that is not blank (ie has a job number in it) and multiply it by 0.5
|