Adding time in Excel

M

MovieSchedules

What I need are start and end times.

I have a start time cell that shows 12:00pm
I have a project that will take 2 hours and 30 Minutes in another cell

Then what I can't figure out how to do is get a cell that will display what
time this project will get out.

Any Ideas
 
B

Bob Phillips

Start time in A1
Run time in B1
In C1: = A1+B1

and format as time.

What would you want to happen if it runs over midnight? If you just want the
time it will finish, day regardless, the above does that.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding time in a work schedule 5
Formatting question: how to format duration (time spent)? 0
Work Budget Salary vs Real Time Salary 0
Slideshow with black border around it 1
VBA word change keys 0
Default local file location - folder redirection slowness 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Over time? 4

Top