converting value to time

I know how to do the time format but my question is from the value that is calculated, how do i show it in time format? (the calculation will save time )

Again from the first example, if the building costs 100 credits, and the construction time is 50 credits per hour, then the building will take 2 hours to build (which will show 02:00:00) or if the building cost is 50 credits, and the construction time is 100 credits, then the building will take 1/2 hour to build (00:30:00)

Well perhaps I'm thinking more of Stopwatch time than the normal time

I thought I replied to the thread... must of been a browser error

Jimmy's handy work made me realize what I was missing... the 24 to convert to the hours/mins/secs that I needed.

Thanks for you help guys! I will be sure to add you in the credits

psff.. fine

Also I was wondering... a couple of years back I was able to change the color of the text and fill of a cell by using formulas. Does anyone remember how to? Like for example, A1 is the cell changing color. The formula will be if A2 = 1 then the cell would be green, 2, cell is yellow, 3 cell is red.

I only need one