Help needed!!

GemLeigh92

New Member
Joined
Feb 24, 2016
Messages
2
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 inLog OutHrs worked
Monday9:00 AM5:00 PM7
Tuesday9:00 AM8:00 PM10
Wednesday9:00 AM7:00 PM9
Thursday9:00 AM7:00 PM9
Friday-1
Saturday-1
TOTAL33.00

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

vicedo

Active Member
Joined
Jan 9, 2015
Messages
401
The formula below works if either of B6 or C6 is blank

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

Alex Hospers

New Member
Joined
Feb 13, 2016
Messages
8
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,322
Messages
5,600,951
Members
414,417
Latest member
Nobu

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top