calculating remining time in hours knowing the parts left and target

[pawwwd]

Hi All,

I'm trying to write a formula that is going to calculate time to finish parts in hours, for example i have 35000 parts making 550 per hour how long is going to take me to finish it in hours and minutes. I tried changing the numeric to time but its working only in 24h time it doesnt give me the exact time in hours and minutes

 

[BSALV]

Map1
	A	B	C
1	35 500	550	64:32:44
Blad1

Cell Formulas
Range	Formula
C1	C1	=+A1/(24*B1)

 

[pawwwd]

Hi BSALV,

thanks for replying, do i have to format them somehow? because its still showing me the wrong time...

Map1
	A	B	C
1	35 500	550	64:32:44
Blad1

Cell Formulas
Range	Formula
C1	C1	=+A1/(24*B1)

 

[Sufiyan97]

Hii

Select time format as below

 

[hicksi]

What are those Time Formats? My dropdown has only 4.
OMG, if you switch to English (United States) there's more formats. What-The-Hell...

And now I see that if I select Custom with that set to
'[h]:mm:ss'
Is THAT the requirement?

 

[Fluff]

do i have to format them somehow?

Yes, select a custom format of [h]:mm

 

[hicksi]

Took ME some time to understand, too:
hh:mm shows only the remaining hours and minutes, (removing the days portion of the time)
dd hh:mm shows days, hours and minutes.
and [h]:mm shows the whole hours and minutes. I had NEVER come across the [h] concept before.