Try =A1+TIME(0,B1,0) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jochen Munzinger" <external.jochen.munzinger@de.bosch.com> wrote in message news:e90105$pba$1@ns2.fe.internet.bosch.com...
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
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@de.bosch.com> a écrit dans le message de news: e90105$pba$1@ns2.fe.internet.bosch.com...
Hi Jochen, In B2 put =A2+B1/24/60 and format cell as [h]:mm HTH Martin