How to format answer with time in the equation?

[violet1905]

Hi,

I have a formula that subtracts two times to come up with an answer in minutes and then divide the minutes by the number of scans done to come up with "scans per minute" but my answer doesn't make sense. I think it has to do with the formating of the numbers but can't figure out what I'm doing wrong.

Any help would be appreciated.

Thanks

 

[VoG]

Maybe

=TEXT(A1/B1,"hh:mm")

 

[violet1905]

Hmmm. No that didn't work. I am dividing 50 minutes by 616 scans and it gives me 19:12. According to the adding machine it should be 12.32 minutes. Thanks for replying

 

[T. Valko]

Hi,

I have a formula that subtracts two times to come up with an answer in minutes and then divide the minutes by the number of scans done to come up with "scans per minute" but my answer doesn't make sense. I think it has to do with the formating of the numbers but can't figure out what I'm doing wrong.

Any help would be appreciated.

Thanks

You have to convert the total time to decimal minutes then divide.

=(end_time-start_time)*1440 / number of scans

And then, you might want to round that result.

 

[violet1905]

Thank you!!!!!!!!

 

[T. Valko]

Thank you!!!!!!!!

You're welcome!