hi
something like this might work
=RIGHT(E2,5)-LEFT(E2,5)
but each time would have to have 5 characters
9:30 - 9:45 would need to modify the formula to =RIGHT(E2,4)-LEFT(E2,4)
but 09:30 - 09:45 would work with the 5 character formula.

regards
FSt1

"JW73" wrote:

In Excel 2003, is it possible to calculate time duration when a single cell
has a time range of HH:MM-HH:MM (ex. 10:30-14:30)? I know its possible to do
so when comparing data from different cells, but I'm having trouble doing so
when both times are in a single cell - trying to pull report data from a file
export, having the times in 2 cells isn't an option.