Microsoft Excel - Convert Time Range to Hours - Asked By Dan on 13-Jun-14 11:18 AM

How can I convert this to an single number in Excel?

15:30 - 16:30 convert to 1

Harry Boughen replied to Dan on 13-Jun-14 04:23 PM
Hello Dan,
Assuming it is a string and the times are always hh:mm format in cell A1 then the following will do what you want.


Dan replied to Harry Boughen on 16-Jun-14 10:58 AM
Thank you, that work!