# Thread: using time calculations (xp)

1. ## 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. ## 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. ## 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
•