Convert number to time.

[Floyd Forbes]

Help!
If a person require to run 36000 items per hour. How do I
show in excel converting 36000 to one hour using time format.
I tried 36000/60/60 = 0:00:00 did not work.

Thanks

 

[Bernie Deitrick]

If the number of items is in cell A1, then

=A1/36000/24

and formatted for time will show the time in hrs:mm:ss that it should take to run.

HTH,
Bernie
MS Excel MVP

 

[Floyd Forbes]

Thank you. It works, but why A1/36000/24 works?

If the number of items is in cell A1, then

=A1/36000/24

and formatted for time will show the time in hrs:mm:ss that it should
take to run.

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

Floyd,

Since you need 36000 per hour, dividing by 36000 gives the number of hours.
Dividing by 24 puts it into the time format that Excel uses, which is 1 = 1
day = 24 hrs.

Bernie

 

[Floyd Forbes]

Thank you for your help.

Floyd,

Since you need 36000 per hour, dividing by 36000 gives the number of
hours. Dividing by 24 puts it into the time format that Excel uses, which
is 1 = 1 day = 24 hrs.

Bernie