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
|