find out days of working

[amirhosseini]

Hi

I have a problem in calculating the number of days working in my sheet.
I have a weekly timesheet and each person has his time in and time out for each day in seperate cell (e.s Time in (cell B2) and time out (cell C2) and so on for the rest of days in the week) some times they have day off and in there the cells of in and out are empty.
so i need a way to calculate the days that they work and if there is empty it doesnt

how to count two cells with value in it as 1 day and if its empty is 0 ?

please help me

[Pepe Le Mokko]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[pwnyadav007]

u can use count function for that
=count(B2:C2)-1
this will give u 1

[amirhosseini]

Hi
Thanks a lot for your reply. in attach I leave the workbook, in the sheet I show the problems with arrows and as you asked I did an example with the value insert manually.
here is the attachment TIMESHEET.xlsx

Thank you

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[pwnyadav007]

I thin this is what u want

TIMESHEET.xlsx

[amirhosseini]

you are wonderful thanks a lot xxxxx