formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a Timesheet I would like to add the total time for weekend days seperately
from the weekdays. So I would like to add all weekdays, not Sunday and
Saturdays, and Saturday and Sunday together.Thanks, Mon
 
How is your sheet structured? Names going down column A with dates
going across? One week, or one month per sheet? Do you want two columns
for the total times, weekdays and weekend?

A bit more detail, please.

Pete
 
Thanks, It's very basic 2 week timesheet. Rows are date, day of the week,
number of hours worked, number of hours travelled, number of Kilometres.
Payment for the hours worked is greated for the weekend. Summaries are at
the bottom so that PayRoll Officer can easily do pays.
 
You must log in or register to reply here.

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

WEEKDAY 7
Sumif weekday 3
Ok how about this formula using days :-/ 1
Literal based on Week end 3
overtime during weekdays and weekend ( more specified) 2
Re: How can I count the number of SATURDAYS in a month? 0
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Only weekdays (sysgulv) 5

Back
Top