Debbie,

Use
=SUM(cells)/1440
and format that cell as time (hh:mm:ss)

1440 is the number of minutes in a day (24*60), which converts the sum of minutes to fractions of a
day (a value between 0 and 1), which is how Excel does timevalues.

HTH,
Bernie
MS Excel MVP


"Debbie" wrote in message
...
I'm sure I'm overlooking something simple...
Please help:

I'm adding time differences of:
0.02 (Minutes)
0.09
0.02
0.99
0.20

My total minutes equal:
132

I want to convert this number to the number of hours minutes which should be:
2:12

I can't seem to wrap my brain around this to find the answer.