Creating a Timesheet/Calculating Time

**mgarcia1234** · 02-24-2005, 02:52 PM

I need to create an Excel spreadsheet (2000 ver) where I can enter hours and minutes in separate cells, then have them total up all together as hours and minutes.

I've been given the task of having to calculate all the time I've spent on certain projects, so the number of hours/mins to calculate will change over time as I add/subtract time.

I'll try to illustrate in an example:

Please Login or Register  to view this content.

I've never had to make a formula in a spreadsheet other than "=sum(cell:cell)" so I have no idea how to go about it.

I'm sure for an experienced Excel user, this is a no-brainer. Did I also mention that I suck at math?!

~MGarcia1234
([email protected])

**HiArt** · 02-25-2005, 08:15 AM

Hi MGarcia1234,

this might work.

In the cell to total the hours column try:
=SUM(A2:A4)+INT(SUM(B2:B4)/60)
A2:A4 is the range of cells containing hours, B2:B4 is the range of cells containing minutes.

In the minutes total cell try:
=MOD(SUM(B2:B4),60)
B2:B4 is the range of cells containing minutes.

HTH

Art