# Help needed!!

#### GemLeigh92

##### New Member
If anyone can help, I'm usless when it comes to excel but my boss wants a timesheet done. I have downloaded one from online and want to keep it as simple for her as possible. I'm trying to apply a formual that if nothing is entered then it stays blank and doesnt calculate with me taking off the -1 hour for lunch breaks. Formual i have already is =SUM(C6-B6)*24-1

Can anyone help? Thanks, Gemma

 Week of 29/02/15 Log in Log Out Hrs worked Monday 9:00 AM 5:00 PM 7 Tuesday 9:00 AM 8:00 PM 10 Wednesday 9:00 AM 7:00 PM 9 Thursday 9:00 AM 7:00 PM 9 Friday -1 Saturday -1 TOTAL 33.00

<tbody>
</tbody>

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
The formula below works if either of B6 or C6 is blank

=IF(COUNT(\$B6:\$C6)<>2,"",SUM(C6-B6)*24-1

The formula below works if either of B6 or C6 is blank

=IF(COUNT(\$B6:\$C6)<>2,"",SUM(C6-B6)*24-1

Thank you so much for the quick reply, it worked, thank you thank you!!

Following might work:

=IF(OR(ISBLANK(C3); ISBLANK(D3));"";(D3-C3)*24-1)
What this does, if c3 is empty OR d3 is empty, do nothing, otherwise (D3-C3)*24-1

And so you can make several nested IFs, not easy, but practice makes masters

Replies
0
Views
264
Replies
10
Views
580
Replies
5
Views
269
Replies
0
Views
157
Replies
1
Views
282

1,218,809
Messages
6,144,606
Members
450,559
Latest member
kwenda farai

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back