Extract DateStamps from Excel & create a progress bar

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 .