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

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>

 

[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