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 `2013-09-22 09:10`

?

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.

`TIME`

formula does not work is: The decimal number returned by TIME is a value ranging from0(zero) to0.99999999[which means that after 24 hours have been added, it wraps around again - see what happens if you add 1440 minutes using this method] – SeanC Sep 24 '13 at 16:26