I am having a problem figuring this out and I'm sure it is quite simple and
maybe I am trying to hard but I have a worksheet that an employee enters how
many minutes they worked on something. Each employee has a separate column
that they enter their time. What I want to do is sum up all their time
(minutes) to produce the total hours and minutes for that particular task.

Any help would be greatly appreciated.

Well, I think a simple =sum() would be in order. If you're dealing with time
sheets, look at this template:
http://www.vertex42.com/ExcelTemplat...timesheet.html

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Kimbe" wrote:

I am having a problem figuring this out and I'm sure it is quite simple and
maybe I am trying to hard but I have a worksheet that an employee enters how
many minutes they worked on something. Each employee has a separate column
that they enter their time. What I want to do is sum up all their time
(minutes) to produce the total hours and minutes for that particular task.

Any help would be greatly appreciated.

If you're entering time in minutes (as a decimal number), you can convert it
to an Excel time with the following formula:
=a1/60/60
Format as time.

Then just sum the numbers.
If your numbers add up to more than 24 hours, use a format of [hh]:mm to
display it.

Regards,
Fred

"Kimbe" wrote in message
...
I am having a problem figuring this out and I'm sure it is quite simple and
maybe I am trying to hard but I have a worksheet that an employee enters
how
many minutes they worked on something. Each employee has a separate
column
that they enter their time. What I want to do is sum up all their time
(minutes) to produce the total hours and minutes for that particular task.

Any help would be greatly appreciated.

In cell A 1 I have:-

Employee1

In cell B 1 I have:-

Employee2

In cell C 1 I have:-

Employee3

In cells A 2 down to A 25 inclusive I enter:-

30

This is the number of minutes that Employee1 has worked.

In cell A 26 I have the following formula:-

=SUM(A2:A25)/60

This returns (shows in cell A 26) the number 12 - being the 12 hours worked
by Employee1.

Copy the above to other cells as required.

If my comments have helped please hit Yes.



"Kimbe" wrote:

I am having a problem figuring this out and I'm sure it is quite simple and
maybe I am trying to hard but I have a worksheet that an employee enters how
many minutes they worked on something. Each employee has a separate column
that they enter their time. What I want to do is sum up all their time
(minutes) to produce the total hours and minutes for that particular task.

Any help would be greatly appreciated.

Sorry, I meant:
=a1/60/24

Regards,
Fred

"Fred Smith" wrote in message
...
If you're entering time in minutes (as a decimal number), you can convert
it to an Excel time with the following formula:
=a1/60/60
Format as time.

Then just sum the numbers.
If your numbers add up to more than 24 hours, use a format of [hh]:mm to
display it.

Regards,
Fred

"Kimbe" wrote in message
...
I am having a problem figuring this out and I'm sure it is quite simple
and
maybe I am trying to hard but I have a worksheet that an employee enters
how
many minutes they worked on something. Each employee has a separate
column
that they enter their time. What I want to do is sum up all their time
(minutes) to produce the total hours and minutes for that particular
task.

Any help would be greatly appreciated.