+ Reply to Thread
Results 1 to 3 of 3

Total TIme worked

  1. #1
    Registered User
    Join Date
    01-04-2006
    Posts
    11

    Total TIme worked

    I am working on a spreadsheet which contains how many hours worked per day and totals for the week and month. I am using the =TEXT(B2-A2,"h:mm") formula to get the difference betwen the time I log in and the time I log out to obtain my total hours for the day. Now how do I add all those times to get the total worked for the week?
    Then I want to total those 4 values for total time worked during the month.
    Should I not use the TEXT function? I tried just subtracting them but then the total time does not come out right.
    THanks for you help.
    Jennifer

  2. #2
    Registered User
    Join Date
    01-04-2006
    Posts
    33
    Take a look at this site it should put you on the right track.
    http://www.cpearson.com/excel/overtime.htm

  3. #3
    Registered User
    Join Date
    01-04-2006
    Posts
    11
    Thanks so much. It seems to be working now!
    Jennifer

+ 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