Working out the time?

[ajw150]

Hi,

Is it possible to calculate how many hours are between 11:00-16:00 if they are written in the same cell.

i.e A1 will say 11:00-16:00

Is this possible or do the times have to be written in two seperate cells?

thanks

Andrew

[daddylonglegs]

Hello Andrew, you can do this all in one cell if your data is consistent, i.e. if you have times before 10:00 shown with leading zeros, e.g.

09:00-17:00

If data is in A1 try

=MOD(RIGHT(A1,5)-LEFT(A1,5),1)

format result cell as h:mm