add minutes to a given time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jochen Munzinger - 11 Jul 2006 12:11 GMT

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

Reply to this Message

MartinW - 11 Jul 2006 12:37 GMT

Hi Jochen,

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

HTH
Martin

Reply to this Message

Ardus Petus - 11 Jul 2006 12:41 GMT

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

HTH
--
AP

> Hey there,
>
[quoted text clipped - 7 lines]
>
> Jochen

Reply to this Message

Chip Pearson - 11 Jul 2006 16:14 GMT

Try

=A1+TIME(0,B1,0)

Signature

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

> Hey there,
>
[quoted text clipped - 9 lines]
>
> Jochen

Reply to this Message

Rate this thread: