how is the data setout
perhaps a sample
you can use a weekday() to identify the weekend and monday
=WEEKDAY(A1,2)>5
that will tell you its a weekend
then you can add some times in and using an
IF , OR , AND
and then you could have a column with a 1 to show the overtime
but how about
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Bookmarks