I have the following cell:
0800-1000

I need to ref 0800 in one column & 1000 in another, to ultimately subtract
0800 from 1000 to get 2 hours.

What function would do that ?

Thanks,

Steve

Why making it so hard? Why not use sense and use 2 cells and

08:00 and 10:00

then you can just use

=B1-A1

assuming B1 holds 10:00 and A1 08:00
of course if you are the receiver of a sheet that comes like that it aint
much to do

if the times can go after midnight like

1930-0230

=MOD((INT(RIGHT(A1,4)/100)+MOD(RIGHT(A1,4),100)/60)/24-(INT(LEFT(A1,4)/100)+MOD(LEFT(A1,4),100)/60)/24,1)

if not


=TEXT(RIGHT(A1,4),"00\:00")-TEXT(LEFT(A1,4),"00\:00")


format as hh:mm


Regards,

Peo Sjoblom



"Steve" wrote:

I have the following cell:
0800-1000

I need to ref 0800 in one column & 1000 in another, to ultimately subtract
0800 from 1000 to get 2 hours.

What function would do that ?

Thanks,

Steve

Thanks,

Yes, the data was imported into that cell as 0800-1000, so I'll need to use
your latter suggestions.

Thanks again,

Steve

"Peo Sjoblom" wrote:

Why making it so hard? Why not use sense and use 2 cells and

08:00 and 10:00

then you can just use

=B1-A1

assuming B1 holds 10:00 and A1 08:00
of course if you are the receiver of a sheet that comes like that it aint
much to do

if the times can go after midnight like

1930-0230

=MOD((INT(RIGHT(A1,4)/100)+MOD(RIGHT(A1,4),100)/60)/24-(INT(LEFT(A1,4)/100)+MOD(LEFT(A1,4),100)/60)/24,1)

if not


=TEXT(RIGHT(A1,4),"00\:00")-TEXT(LEFT(A1,4),"00\:00")


format as hh:mm


Regards,

Peo Sjoblom



"Steve" wrote:

I have the following cell:
0800-1000

I need to ref 0800 in one column & 1000 in another, to ultimately subtract
0800 from 1000 to get 2 hours.

What function would do that ?

Thanks,

Steve