How do i calculate the start date and time from an ending date an.

G

Guest

I need to find out when a job started, based on its completion date, time,
and duration in hours,minutes, and seconds.

ie: (job end date, formatted as date) A1 = 09/13/2004, (job end time,
formatted as time) A2 = 20:00:00, (job duration, formatted as time) A3 =
49:00:00


Calculating the asnwer manually we should end up with a start time of
9/11/2004 19:00:00

Thanks in advance for any help. :)
 
N

Niek Otten

Must be a machine of some kind, probably a Japanese one. Fortunately the
poster gave an example!

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

Calculate elapsed time excluding specific timeframe 10
WORK HOURS DIFFERENCE BETWEEN TWO DATES 12
Calculating Project Time 1
Work Hours 1
date and time difference 19
HELP! I need to make an IF Statement comparing date/time fields.. 2
How to enter start and end date/time in excel based on some specific value. 7
Calculate the duration between the end time and start time of anot 4

Top