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

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

In A2: 7:31 AM
In B2: 847 (a number, representing minutes)

Put in C2:
=IF(A2="","",A2+B2/(24*60))
Format C2 as: h:mm AM/PM
C2 will return: 9:38 PM
(presume your posted 9:53 PM is a typo?)

Copy C2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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