Summing Up My Time (minutes)
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.
|