| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to add hours 9/weekday & 4.5/w/e / 7day week columns
Can anyone tell me the formula to add hours 9/weekday & 4.5/sat & all
hours worked sunday. 7 columns starting wed finishing Tues. Cheers Bridget |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to add hours 9/weekday & 4.5/w/e / 7day week columns
Clear questions get quick answers. Lack of an answer means your question is
not clear. To add hours, use the Time function, as in: =a1+time(9,0,0) If you need something else, post back with more detail, especially an example of what you want to achieve. Fred "bridget" wrote in message ... Can anyone tell me the formula to add hours 9/weekday & 4.5/sat & all hours worked sunday. 7 columns starting wed finishing Tues. Cheers Bridget |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours scheduled for week | Excel Worksheet Functions | |||
| calulating a certain weekday hours within a 24 hour roster | Excel Worksheet Functions | |||
| Calculate DATE from Weekday and Week # | Excel Discussion (Misc queries) | |||
| How do I calculate the week day hours between 2 days | Excel Discussion (Misc queries) | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Linear Mode
