Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    using time calculations (xp)

    I am trying t produce a simpel!!!! timesheet.

    I find I can easily calculate the no of hours between check in and check out and even allow a break period. But when I come t o total the no of hours per week, Excel tries to accumulate the hours so I just find out what time it would be if the hours followed one after the other.

    Help suggests that if more than 24 hours you add *24 to the sum calculation and format as a general number field. This works fine if you have no more than 15 minute units. Which gives you .25 , .50, 75 etc.

    Many people in uk with timesheets work to 6 minute units - 10 per hour. If you start putting these in you get really strange totals. Can anyone please suggest a way I can get Excel to calculate in 60s rather than 10s!

    All I am seeking is an hour plus minute total of time worked.

    Thacks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: using time calculations (xp)

    You don't need to multiply by 24. Format the sum as [hh]:mm instead of hh:mm. The square brackets allow for hours above 24, for example 37:18.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: using time calculations (xp)

    Roberta,

    John Walkenbach has a timesheet you can download at his excellent site:

    http:// http://j-walk.com/ss/excel/files/timesht.htm

    It may not be exactly what you want but it may have some useful ideas in it.

    Also you might like to look at Chip Pearson Excel site for useful information about times:

    http:// http://www.cpearson.com/excel/topic.htm

    Good Luck!

    Peter Moran
    Two head are always better than one!

Posting Permissions

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