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.
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.