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