adding many minutes

[act13]

Hi
I have a date/time in A1: 1/1/2011 10:00
I want to add 5000 (or any amount of) minutes to it
A1 + time(0,5000,0) doesn't work because it seems to have an upper limit of seconds, hours, minutes you can use.
What can i use to add time that has no limit?

thanks
-Alan

 

[act13]

duh. never mind
i just add A1 + 5000/60/24 which adds the minutes calculated as a day

 

[Scott Huish]

And of course a little shorter (where B1 holds the minutes you want to add):

=A1+(B1/1440)