calculating the finish time/date from the start time/date

S

swiss tony

'ello 'ello

i'm confused...nothing new

i know the "start time" and the "start day" and "start date" and i know
the "duration time" of the process. What will be the "finish time"
"finish day" and "finish date"?

Is there a formula to calculate the finish time given the duration
time?

thanks for your time.

peace. jay
 
B

Bernard V Liengme

Hello,
In A1 type Jan-01-03 for start date
In B1 type 3:35 for start time
In C1 type 24:30 for duration (but format it [hh]:mm otherwise it will
display 0:30)
In D1 =A1+B1+C1 will show Jan-02-2003 4:15 (looks right to me)
Bernard
 

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

Top