formula to add hours > 9/weekday & 4.5/w/e / 7day week columns

  • Thread starter Thread starter bridget
  • Start date Start date
B

bridget

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
 
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
 
Back
Top