One way:

=SUM(A1:A2)/60


If you want the result as an XL time:

=SUM(A1:A2)/(60*24)

or, equivalently

=SUM(A1:A2)/1440

format as time.

In article .com,
wrote:

I have a worksheet with a several fields that I place in minutes on
projects.
I need to total up the mintues to relect hours.
For example:
A1 , I have 54 minutes
A2 , I have 6 minutes
A3 , I have =SUM(A1:A2)

How do I get A3 to show total of 1 hour?