Convert Hours, day and week values in minutes

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!

Book2.xlsx

Here is the file

that's quite nice, a coworker also showed me the text-to-columns function that works quite nice to separate number from text, and I just if functioned my way to victory.

How could I get the text-to-columns and my if statement in a macro?

Here is if statement

=IF(LEFT(C6,3)="wee",B6*5*7.5*60,IF(LEFT(C6,3)="day",B6*7.5*60,IF(LEFT(C6,3)="hou",B6*60,IF(LEFT(C6,3)="min",B6,B6))))