Adding Minutes

P

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
 
B

Bob Phillips

=A1+TIME(0,10,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
M

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
 
P

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
Click to expand...
 
Top