Calculating hours worked from one cell

[dogo]

Hi All,

Im trying to calculate the number of hours that has elapsed say form one cell.

Cell A1 has a string which contain 09:45-13:57 how would I calculate the hours elapsed.

Can anyone point me in the right direction.

Regards

Dogo

[63falcondude]

Hello and welcome to the forum.

You can use this:
=RIGHT(A1,5)-LEFT(A1,5)
Formatted as Custom h:mm

or you can use this:
=(RIGHT(A1,5)-LEFT(A1,5))*24
for the number of hours