G
Guest
I'm pasting text into excell & need a decimal count of minutes. The problem
comes in that some text is refering to hours and sometimes to minutes & I
can't come up with a formula to handle both.
Ex: Paste the following
A1 - 2:00
A2 - 3:00
A3 - 3:00:00
A4 - 3:40:00
Should convert to
A1 = 2
A2 = 3
A3 = 180
A4 = 220
Thanks!
comes in that some text is refering to hours and sometimes to minutes & I
can't come up with a formula to handle both.
Ex: Paste the following
A1 - 2:00
A2 - 3:00
A3 - 3:00:00
A4 - 3:40:00
Should convert to
A1 = 2
A2 = 3
A3 = 180
A4 = 220
Thanks!