Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
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. "Pete_UK" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |