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
 

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

Similar Threads

UDF To Calculate Work hours between two dates Problem with code 4
Working out a future date with formulas 3
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
which one to use: Macros / Formula's / Lookup 4
Calculating Working Hours, Days and Overtimes. 1
prompt for weekday and distribute the dates in columns 6
Timesheet Overtime Calulations - Excel 2002 5
Calculate Total hours worked during workdays within given shift time. 2

Back
Top