+ Reply to Thread
Results 1 to 4 of 4

Sum of working hours

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    ploiesti
    MS-Off Ver
    Excel 2003
    Posts
    4

    Sum of working hours

    I need to create a table of hours of work all year long, where every day I must sum the last 28 days.
    How can I get sum of the hours of work each day?
    For exemple.. like in the file... from April 18 untill Mai 16 (marked with red) I have a total of 15 58 hours. Next I need a sum from April18 untill May17.
    Thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-01-2010
    Location
    High Wycombe
    MS-Off Ver
    Excel 2003
    Posts
    95

    Re: Sum of working hours

    Hello,

    I cannot open the file, can you resave as .xls?

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Sum of working hours

    Hi James

    if you want to, you can download a free converter from MS to convert xlsx to xls

    EDIT although the OP's file seems a bit weird to me...
    Last edited by Pepe Le Mokko; 07-12-2012 at 02:26 AM.

  4. #4
    Registered User
    Join Date
    07-11-2012
    Location
    ploiesti
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Sum of working hours

    Ohh.. sorry. I can not save right now.. I am at work, and here I have Linux... and I get a error when tring to save xls. Immagine a table with every mount in colums, and on rows are days.... In every day I get a numer of hours of work.... and I need a sum of hours of work from April 18 untill Mai 16. next sum.. 19 april untill Mai 17, next 20 april untill Mail 18 and so on..

+ 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