R
RJB
I have a really simple form that is to figure how long something is going to
take. I know all the information needed, the problem is getting it to
display properly. Here's the example.
50 copies of 200 pieces. (=10,000)
The machine runs at 90 pieces per hour. (=111.1111111)
How many hours will it take to finish? (= 1.85)
I need to display 1.85 as 1 hour and 51 minutes (1.85 in hours:minutes)
Simply changing the display format to "Short Time" does not work...it comes
up with 20:26
How can I do this?
take. I know all the information needed, the problem is getting it to
display properly. Here's the example.
50 copies of 200 pieces. (=10,000)
The machine runs at 90 pieces per hour. (=111.1111111)
How many hours will it take to finish? (= 1.85)
I need to display 1.85 as 1 hour and 51 minutes (1.85 in hours:minutes)
Simply changing the display format to "Short Time" does not work...it comes
up with 20:26
How can I do this?