add minutes to a given time

[Jochen Munzinger]

Hey there,

in cell A2 I have a time, say 07:00 hrs. In B1 in have i.e. 3 minutes of
time an operation takes. Now I want to add those 3 minutes to the time in
A2, so I have 07:03 hrs in cell B2

How do I have to format the cells to get that done?


Thanx well in advance!

Jochen

 

[MartinW]

Hi Jochen,

In B2 put =A2+B1/24/60 and format cell as [h]:mm

HTH
Martin

 

[Ardus Petus]

In A2, enter: 07:00
in B1, enter: 00:03
in B2, enter: =A2+B1
format all those cells as hh:mm

HTH

 

[Chip Pearson]

Try

=A1+TIME(0,B1,0)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com