add minutes to a given time

J

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
 
A

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
 
Top