Adding Minutes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paul_black27@hotmail.com - 28 Jan 2006 10:11 GMT

Hi Everyone,

If I have the time 14:45 and I wanted to add say 10 minutes to it, how
would I do this please.

Thanks in advance.
All the Best.
Paul

Reply to this Message

Bob Phillips - 28 Jan 2006 10:19 GMT

=A1+TIME(0,10,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> Hi Everyone,
>
[quoted text clipped - 4 lines]
> All the Best.
> Paul

Reply to this Message

paul_black27@hotmail.com - 28 Jan 2006 10:26 GMT

Thanks Very Much Bob.

All the Best.
Paul

> =A1+TIME(0,10,0)
>
[quoted text clipped - 14 lines]
> > All the Best.
> > Paul

Reply to this Message

Max - 28 Jan 2006 10:23 GMT

In A1: 14:45
In B1: 10 (the minutes to be added)

Then in say, C1: =A1+B1/(24*60)
C1, formatted as Time ("13:30"), will return: 14:55
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi Everyone,
>
[quoted text clipped - 4 lines]
> All the Best.
> Paul

Reply to this Message

paul_black27@hotmail.com - 28 Jan 2006 10:39 GMT

Thanks Very Much Max.

All the Best.
Paul

> In A1: 14:45
> In B1: 10 (the minutes to be added)
[quoted text clipped - 15 lines]
> > All the Best.
> > Paul

Reply to this Message

Max - 28 Jan 2006 10:43 GMT

You're welcome, Paul.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thanks Very Much Max.
>
> All the Best.
> Paul

Reply to this Message