Thread: Adding time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gringarlow Gringarlow is offline
external usenet poster
 
Posts: 15
Default Adding time

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