count time

[JOEE1979]

07:00-15:00 (this is whats in cell D8)
This represents the time my worker is supposed to be at work.
I cannot change this format.
Is there a formula I can write to count the amount of hours worked?

Thank you

 

[Scott Huish]

=(MOD(TEXTAFTER(D8,"-")-TEXTBEFORE(D8,"-"),1))*24

 

[JOEE1979]

=(MOD(TEXTAFTER(D8,"-")-TEXTBEFORE(D8,"-"),1))*24

Awesome, thanks

 

[JOEE1979]

=(MOD(TEXTAFTER(D8,"-")-TEXTBEFORE(D8,"-"),1))*24

I modified the formula to look like this
=IFNA((MOD(TEXTAFTER(B9,"-")-TEXTBEFORE(B9,"-"),1))*24,"0")

is there a way to make the formula auto count all the cell in column B?

 

[Scott Huish]

Try this and you should be able to drop your IFNA too:
=IF(B2:B100="",0,(MOD(TEXTAFTER(B2:B100,"-")-TEXTBEFORE(B2:B100,"-"),1))*24)

 

[Peter_SSs]

I modified the formula to look like this
=IFNA((MOD(TEXTAFTER(B9,"-")-TEXTBEFORE(B9,"-"),1))*24,"0")

Given that your time format looks like it is probably uniform, then for a single cell, another option might be

=IFERROR(MOD(RIGHT(B9,5)-LEFT(B9,5),1)*24,0)

.. or for the whole column

=IFERROR(MOD(RIGHT(B2:B100,5)-LEFT(B2:B100,5),1)*24,0)

If your times never span midnight then the formulas could be a bit shorter again.