Format the cells
Custom hh:mm
Then use formula

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"da" wrote:

Sorry to mislead you. However times are shown as following:
3:50 PM 4:25 PM
5:30 PM 6:30 PM
4:10 PM 6:40 PM
6:40 PM 8:45 PM
6:55 PM 8:50 PM
3:15 PM 5:45 PM
4:05 PM 5:15 PM


"Russell Dawson" wrote:

Missed something

I'm assuming your input is in following format

0:00



--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"da" wrote:

Good Morning
Is there any way I can convert following to minutes using a formula or any
other way?
Thank you

35 Min
1 HR
2 Hr 30 min
2 Hr 5 min
2 Hr 5 min
2 Hr 30 min
1 Hr 10 min
2 Hr
2 Hr 15 min
3 Hr 5 min
1 HR