I am using a spreadsheet where column A will have as part of the cell text string L3 or L4. I need a formula elsewhere on the spreadsheet whereupon if the cell in the column contains L3 it will put 00:45 in another cell but if the cell in the column contains L4 it will put 01:00. I need help with correct formula.
In my own words,
If cells A1:A50 contain text string L3 type 00:45 in this cell but if the text string L4 appears type 01:00 instead.