J
JRO Mtn Group
How do I create a formula that converts a Outlook Journal Duration to a
number that represents hours:For Instance - I want the following to all be
hours without the word "Hours" or "Hour" or "minutes" (I want to use the
number of hours in another formula....
Duration
3.5 hours
1 hour
45 minutes
2 hours
All this is in one column -
I got as far as if(isnumber(search("hour",A2)), but now what? How do I get
the 3.5 to use it in a formula...
Thanks
number that represents hours:For Instance - I want the following to all be
hours without the word "Hours" or "Hour" or "minutes" (I want to use the
number of hours in another formula....
Duration
3.5 hours
1 hour
45 minutes
2 hours
All this is in one column -
I got as far as if(isnumber(search("hour",A2)), but now what? How do I get
the 3.5 to use it in a formula...
Thanks