To get the Completion Date,Day and Remaining Time for a Given task when % is provided

To get the Completion Date,Day and Remaining Time for a Given task when % is provided

I have an Activity / Task Tracker where I have the Timing Fixed for a particular Activity however the Activity can be started anytime during the Day as people work 24X7 and therefore knowing the Finishing Time , Date and Day becomes crucial..

I would also appreciate if we could get the Starting Time and Date and Day if we are mentioning the percentage completion so we move backwards and forwards..

Also, its important to know the Remaining time in the below format:

Please Login or Register  to view this content.

.

Please find the attachment for detaisl..

Warm Regards
e4excel.

I think you need to explain more fully

Perhaps...

D2: =G2-F2/1440
Custom Format applied of: dd-mmm-yy hh:mm:ss
(amend per pref.)

J2: =I2/1440
Custom Format applied of: [hh]:mm:ss

L2: =G2+I2/1440
Custom Format applied of: dd-mmm-yy hh:mm:ss
(amend per pref.)

You would adjust the time element of the format to: hh:mm:ss AM/PM