First, you're gonna have to decide on how you enter time.

I'd enter:
00:30:00
for 30 minutes

Then you can just =sum(A1:A2) or =a1+a2
to get the total
(Format the results as [hh]:mm:ss if you could go over 24 hours)

Same thing with the
00:40:00
06:30:00
to get
07:10:00

By entering .30 for 30 minutes and 40 for 40 minutes is going to cause lots of
problems.



Lilbit wrote:

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!!

--

Dave Peterson