View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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