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

Arramis · #1 06-11-2009, 05:00 AM

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.

tigertiger · #2 06-11-2009, 05:26 AM

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

tigertiger · #3 06-11-2009, 05:52 AM

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

Welcome to the Excel Forum

Forum Statistics