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.