Distance from Speed and Time

[DJFANDANGO]

I have this small table, where I need to find out the values (in the coloured cells)...

C3 is formatted to hh:mm, C5 and E5 is speed in knots

in Part 1 I need to find out the distance in nautical miles (yellow)

in part 2 I need to find out in E4 what the remaining distance is (A2-C4), then in E3 (blue) I need the time in hh:mm from E4 (distance) and E5 (speed in knots)

Going forward, I will only change A2 (total distance) and the rest should work itself out... no?

Is this possible?

Many thanks guys.

Book1
	A	B	C	D	E
1	Total Distance		Part 1		Part 2
2	59		hh:mm		hh:mm
3		T:	00:30	T:
4		D:		D:
5		S:	4.5	S:	10
Sheet1

 

[6StringJazzer]

C3 is not 30 minutes, it's 30.0208333333333 (which is 30 days + 30 minutes).

If I fix that so it is really 30 minutes, here are the formulas. E3 has custom format
[h]:mm
to be able to show more than 24 hours, if that should ever be the case.

$scratch.xlsm
	A	B	C	D	E
1	Total Distance		Part 1		Part 2
2	59		hh:mm		hh:mm
3		T:	0:30	T:	5:40
4		D:	2.3	D:	56.8
5		S:	4.5	S:	10
Sheet10

Cell Formulas
Range	Formula
C4	C4	=C5*24*C3
E3	E3	=E4/E5/24
E4	E4	=A2-C4

 

[DJFANDANGO]

Thank you!