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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top