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

  • Thread starter Thread starter swiss tony
  • Start date Start 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
 
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
 
Back
Top