=C2-(C1/1440)

=B2+(B1/1440)

=100*SUM(A1:A2)/1440

or if you want the last in decimal hours

=100*SUM(A1:A2)/1440*24


format the first 2 as hh:mm and the last either hh:mm or general

--

Regards,

Peo Sjoblom

"Lilbit" wrote in message
lkaboutsoftware.com...
What formulas would I use for the following:

A1=.30, A2=.30, Total in A3=1 (as in 1 hour)

Adding:
B1=40(minutes)
B2=6:30
Answer in B3=7:10

Subtracting:
C1=40(minutes)
C2=6:30
Answer in C3=5:50

Thanks in advance for your help!!