Thread: How to read a job`s progress in real time?

I want to calculate, based on GMT, time left until some date.
To be more specific:
- 1 job started (by my will) at 12.00 on 5May2009
- same job last`s (by my will) 1 day and 17 hours
I want to be able to read real time in HOURS, MINUTES left until deadline (job`s ending time), when i open spreadsheet on 5may2009 at 15.00 to show me 1 day 14 hours and if i`ll open spreadsheet on 6may2009 at 12.00 to show me 17 hours.
I mean to be able to read, at any given time, a job progress in real time.
Thank you in advance.

YOU should use the NOW() function to get current time...
tks

For example:

at A1 enter the day: 11/6/2009 8:00:00 AM
at B1:

PHP Code:

=A1+2+TIME(3,0,0) 


-- make a deadline with duration - 2 days 3 hours
at C1:

PHP Code:

=INT(B1-NOW()) &" day " & ROUND((B1-NOW()-INT(B1-NOW()))*24,2) & " hours" 


- the result