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

V/r
Dan
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.

=(TIMEVALUE(RIGHT(A1,5))-TIMEVALUE(LEFT(A1,5)))*24

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