Hi, I have a dataset with a column that contains the duration of an event, that lasts up to 24 hours. The format is as follows: xxh xxm where h stands for hours and m stands for minutes. So if an event lasts 20 minutes it'll say 20 m. If an event lasts 2 hours 24 minutes it'll say 2 h 24 m. If it lasts 2 hours it'll just say 2 h. Is there a function I can write, so "20 m would be read as "20" and 2 h 24 m would be read as "144"? I just want the value in minutes. I can't sum anything or use these values in functions until I convert them into numbers. Thanks for your help!
-A
Bookmarks