Hi All,

I have to deal with outlook task dumps and get a history of work done over several years.

For one year's worth, I have over 8000 tasks to process, and I was wondering if there was a macro I could use.

Data being handled by the macro would be the Total Work done per task, which can be in the form of:

15 minutes,
1 hour,
3 hours,
1 day,
2 days
1 week
5 weeks

I would like a macro that could process it so that the 3 hours example would be something like this

3 hours
If hours multiply 3 by 60 = 180

And if 15 minutes, remove the minutes to end up with 15

Where can I get what I need/is there existing code/or can one of you excel gods help me?

Thanks!