Adding time values

[Johnty]

Hi to all,

I'm trying to add time values together,

EG: 1:30 (90minutes) + 0:30 (30 minutes) to return a value of 2:00

Is it possible to do this in Excel?

Thanks in advance,

John.

 

[Bob Phillips]

Yes, just put the two times in separate cells, and add them =A1+A2

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[PCLIVE]

Try this:

=MIN(cell 1)+MIN(cell 2)

HTH,
Paul

 

[Johnty]

Brilliant!

Thanks,

Try this:

=MIN(cell 1)+MIN(cell 2)

HTH,
Paul

 

[Jasvinder Taneja]

Brilliant!

Thanks,

You may also consider formatting the cells as Custom >> [h]:mm
to show the time for >24hrs (elapsed time mode - otherwise these are
converted to dates)