Re: add minutes to a given time



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

HTH
--
AP


"Jochen Munzinger" <external.jochen.munzinger@xxxxxxxxxxxx> a écrit dans le
message de news: e90105$pba$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.