Weekends for timesheet

J

Jenna

i have a worksheet for my flexi timesheet. it automatically populates the
dates for a month in collumn A based on the following formula:

=IF(MONTH($A$18)=MONTH($A$18+ROW()-18),$A$18+ROW()-18,"")

i want it to enter my usual hours in collumn N. but i want it to enter 0:00
if it is a weekend. i.e. IF A18 is a weekday enter 07:30 in cell N18, else
0:00

is this possible???

please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating occupational sick pay entitlement 0
How to calculate out of hours? 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Need help with a Formula 4
Calculating Times for Pay Rates 4
Average Time for Specific Item 9
Running totals from timesheets 1
Need help with Visual Script Code 1

Top