I gang

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 [url removed, login to view] 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 .

Færdigheder: Excel

Se mere: excel progress bar cell, macro progress bar excel 2010, cars using, excel datestamps, excel extract time stamps, create datestamps excel, datestamps excel, macro excel, macro + excel, Jean, Extract, create a excel, bobby, excel colour, excel contains, multiple excel, excel specific, excel amp, excel macro comment, excel cell, extract records, excel text column, excel amp macro, excel create macro, macro create spreadsheet excel

Om arbejdsgiveren:
( 5 bedømmelser ) Toronto, Canada

Projekt-ID: #984491

Tildelt til:

kanadyanako

Kindly see my proposal.

$30 USD in 0 dage
(1 bedømmelse)
1.7

30 freelancers are bidding on average $63 for this job

bharanisrihari

Hello, Excel expert here. Please check PM for details. Thanks!

$50 USD in 2 dage
(58 bedømmelser)
6.3
koolsidz

Please see PMB

$55 USD in 0 dage
(93 bedømmelser)
5.6
mrbrave

Ready to start now...

$65 USD på 1 dag
(82 bedømmelser)
5.4
RajHeartbeat

Hello sir, I'm ready to start. I will work until you get 101% satisfaction. Please refer to the PMB for further details...

$40 USD in 3 dage
(26 bedømmelser)
5.4
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$100 USD in 3 dage
(7 bedømmelser)
5.0
srinichal

I would like to deliver the project

$80 USD in 4 dage
(3 bedømmelser)
4.4
muthumuni

{{{Answer Found!!!}}} - Please check the PMB

$30 USD in 2 dage
(6 bedømmelser)
3.5
IoliteTech

Hi, kindly Check PM

$40 USD in 0 dage
(2 bedømmelser)
2.2
bhogal67

Hi Iam an expert in this and very much interested in your project and can deliver it on and before time

$30 USD in 3 dage
(1 bedømmelse)
1.0
shafi7136

Hi, I express my interest to work with you. Thanks, Shafi

$100 USD in 7 dage
(0 bedømmelser)
0.0
durgeshpratap

we wish to make a relation with you for the lifetime.

$100 USD in 5 dage
(0 bedømmelser)
0.0
parvezn

Hi Iam an expert in this and very much interested in your project and can deliver it on and before time

$45 USD in 3 dage
(0 bedømmelser)
0.0
Karl11099

Hi I'm in the middle of the road with your formula. Sending an attachment with the first function partially finite. ps. Interestingly small task.

$80 USD på 1 dag
(0 bedømmelser)
0.0
jjayamanna81

Please give me a chance.

$30 USD in 3 dage
(0 bedømmelser)
0.0
MikeHagerud

This looks to be very straightforward. If you want it sooner just say so.

$50 USD in 2 dage
(0 bedømmelser)
0.0
LajosArpad

Hello, I'm interested. Best regards, Lajos Arpad.

$250 USD in 7 dage
(0 bedømmelser)
0.0
Manilva

Kindly provide details, I'm serious, accurate, and full time available.

$100 USD in 3 dage
(0 bedømmelser)
0.0
abuh62

Sir, I am very interested to work with you.Thanks.

$50 USD in 2 dage
(0 bedømmelser)
0.0
Automationengg

Ready to start

$30 USD in 7 dage
(0 bedømmelser)
0.0
sabba

Dear Sir, Let me do that. See my PM

$30 USD in 3 dage
(0 bedømmelser)
0.0