To interpret decimals as times instead of decimals, you will have to
work very hard.

Why not enter 26:25 in one cell, 3:50 in another and add the two cells
together. Excel will handle all the details as long as the cell format
is [h]:mm or [h]:mm:ss (which Excel will defalt to if none of the 3
cells had formats applied before you started.

Jerry

Gabe wrote:

Peo,

This one worked, but now I am trying to add 26.25 plus 3.50, yet I come up
with the answer of 29.75. I need it to read the same way so the value would
be (30.15). Is there a way to modify the current formula so that these values
add in multiples of 60 as well?

A1 = 26.25, A2 = 3.50, A3 = A1+A2,
A3 displays (29.75), can A3 display (30.15) instead?

Original Formula you gave me:
=--(INT(SUM(A1:A2)/60)&"."&TEXT(MOD(SUM(A1:A2),60),"00"))