Thread: Drag Formula

Hi. I have the attached simple spread sheet set up and want to drag the formulas down the sheet. At this time, if I drag the formulas I get the last summation shown all down the sheet i.e 66. Is there a way of dragging the formulas and getting a blank cell until I populate number of hours? Thanks.


PLEASE SEE WORKBOOK ATTACHMENT FURTHER DOWN THIS THREAD

Please don't post .pdf or .jpg copies of workbook problems ... post the sample workbook.

Regards

Cell C2: =IF(B2="","",N(C1)+B2)
Cell D2: =IF(B2="","",G$2-C2)

And drag both formulae down.

Regards

Is there any way of excel counting the number of hours for column B from either the date format that I have used or another format?

Not as it stands. Even if you use LEFT and MID to split the free format date column, there is no consistency in the input and it doesn't include the year. So, as such, it is open to human error and would require assumptions to be made about which year is required.

You really need to split the Dates Requested in two, that is, Start Date and End Date ... which presumably are inclusive. You could then use NETWORKDAYS to calculate the number of days in the date range and, from there, work out how many hours per day.

If you wish to pursue this (different question), I suggest you open a new thread.

If this has answered your question, please mark this thread as solved. See my signature for details or the FAQ.

Regards

See the attached example.

Regards