If I have a cell formatted as date+time in Excel, how can I add to this in terms of minutes? It would need to work whether I was adding 20 minutes, or 2,500 minutes.
So, for example if I had this spreadsheet, what formula could I put in
B5 to get a result of
I tried using
=B4+TIME(0,B3,0), but it gives
2013-09-21 09:10 which is a day off. It works fine though if
B3 is less than a day's worth.