Adding time
On Nov 28, 9:13 am, Gringarlow
wrote:
I want to add 847 minutes to 7:31 AM and get 9:53 PM. I have several rows of
data :
Start Time - formatted as 7:31 AM
Duration - formatted as a number that equals minutes
Time Leaving - formatted same as Start Time
I can do this manually each row at a time, but there are 60,000+ rows this
month...
Has anybody come up with a consolidated set of formulas to do this?
Thanks
=a1+time(0,b1,0)
Assuming that a1 is the start time, and b1 is the number of minutes.
Ctk
|