using time calculations (xp)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

Roberta,

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

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

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 [/url]

Good Luck!

Peter Moran
Two head are always better than one!

Reply | Quote