Adding Minutes

[paul_black27]

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

 

[Bob Phillips]

=A1+TIME(0,10,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Max]

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

 

[paul_black27]

Thanks Very Much Bob.

All the Best.
Paul

=A1+TIME(0,10,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[paul_black27]

Thanks Very Much Max.

All the Best.
Paul

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]

You're welcome, Paul.