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

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
 
F

Fred Smith

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
 
Top