Help needed!!

[GemLeigh92]

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

<tbody>
[TD="class: xl65"]Week of 29/02/15 [/TD]
[TD="class: xl66, width: 75"]Log in[/TD]
[TD="class: xl66, width: 93"]Log Out[/TD]
[TD="class: xl69, width: 74"]Hrs worked[/TD]

[TD="class: xl65"]Monday[/TD]
[TD="class: xl67, align: right"]9:00 AM[/TD]
[TD="class: xl67, align: right"]5:00 PM[/TD]
[TD="class: xl71, align: right"]7[/TD]

[TD="class: xl65"]Tuesday[/TD]
[TD="class: xl67, align: right"]9:00 AM[/TD]
[TD="class: xl67, align: right"]8:00 PM[/TD]
[TD="class: xl71, align: right"]10[/TD]

[TD="class: xl65"]Wednesday[/TD]
[TD="class: xl67, align: right"]9:00 AM[/TD]
[TD="class: xl67, align: right"]7:00 PM[/TD]
[TD="class: xl71, align: right"]9[/TD]

[TD="class: xl65"]Thursday[/TD]
[TD="class: xl67, align: right"]9:00 AM[/TD]
[TD="class: xl67, align: right"]7:00 PM[/TD]
[TD="class: xl71, align: right"]9[/TD]

[TD="class: xl65"]Friday[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl71, align: right"]-1[/TD]

[TD="class: xl65"]Saturday[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl71, align: right"]-1[/TD]

[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[TD="class: xl68"]TOTAL[/TD]
[TD="class: xl70"]33.00[/TD]

</tbody>

 

[vicedo]

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

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

 

[GemLeigh92]

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!!

 

[Alex Hospers]

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