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>
 

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
 
Upvote 0
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 :)
 
Upvote 0

Forum statistics

Threads
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.
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
Back
Top