+ Reply to Thread
Results 1 to 2 of 2

How do I calculated total hours per week

  1. #1
    FrankF
    Guest

    How do I calculated total hours per week

    I can calculate total hours per day using the formula =C4-B4+(C4<B4) but can
    not get the week total when using a column total =(d2:d9) How do I get this
    weekly total to work for payroll?

  2. #2
    Aladin Akyurek
    Guest

    Re: How do I calculated total hours per week

    =SUM(D2:D9)

    Custom format the formula cell as: [h]:mm.

    FrankF wrote:
    > I can calculate total hours per day using the formula =C4-B4+(C4<B4) but can
    > not get the week total when using a column total =(d2:d9) How do I get this
    > weekly total to work for payroll?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1