Excel: I can't add minutes to a time format and get the new time 1

[coolcarls]

I have cell A1 formatted to time like this 12:00am.
I have cell A2 with minutes, like 00:26. I need a formula to add the minutes to the time in A1 and come up with the new time ie 12:26 or if the minutes are 61 or 01:01 the the time in A1 should read 01:01pm.
I thought I had a grip on Excel, but the more I do, the stupider I get!!

Thanks in advance,
Carl

 

[SkipVought]

Hi,

you need to convert MINUTES to DAYS

=A1+61/60/24

where 61 is the number of minutes -- could be (OUGHT TO BE) a reference

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[coolcarls]

Bless you Skip....Again! Perfect. Phew