Extract DateStamps from Excel & create a progress bar
$30-250 USD
Igangværende
Slået op cirka 13 år siden
$30-250 USD
Betales ved levering
Using an Excel2007 spreadsheet , I need to extract multiple date stamps and generate a progress bar with those dates.
One cell contains a worklog (can be a long text containing multiple DateStamps records).Here is an example of the content in a cell :
"Approval Comment
----------------
Mike: Approved
25/Feb/2010 1:18:30 PM Bobby
<<From Worklog >> 00000006555581
---------------------------------------------------------------------------------
Authorization Comment
----------------
:
03/Mar/2010 8:03:15 AM Gim
<<From Worklog >> 00000006955581
---------------------------------------------------------------------------------
Approval Comment
----------------
Peter: Approved
01/Nov/2010 9:09:31 AM John
<<From Worklog in Change>> 000000065559581
---------------------------------------------------------------------------------
Implementation
13/Dec/2010 1:09:36 PM Jean
<<From Worklog >> 000000065559581
---------------------------------------------------------------------------------
All cars ready"
I need a progress bar showing in different colours on the right side on a separate [login to view URL] the above example ,there are 3 datestamps
25/Feb/2010 1:18:30 PM
03/Mar/2010 8:03:15 AM
01/Nov/2010 9:09:31 AM
13/Dec/2010 1:09:36 PM
each interval between the dates should be with a different colour .Also,the last interval should be RED if it is longer than a specific time.
This should be a macro compatible with Excel2077-2010 .