How do you extract numbers out of a cell and create a chart with the data
How do you extract numbers out of a cell that is formatted in a 12-hour clock and paste the numbers into another cell? I need the column "Time Duration" to know the difference between the "Start Time" and "End Time" and then on possible another sheet show a chart of over a period of time.
I was even thinking, I could extract the 7:05 and 7:15 (remove the "AM") into one cell, then in another cell reduce it down to 705 and 715 respectively (remove the " : ") then get the difference.
I don't know where to start, please help!
Help Article Resources
Check out the Formula Handbook template!