# converting value to time

972 Views 10 Replies 4 Participants Last post by  Zack Barresse
I am playing an online web-based game and I'm trying to make a spreadsheet so I can keep track of what I have got.

One of the things I have trouble with is how show the build time in hh mm ss of the structures and units. The formula the game seems to be:

(example)

building costs 100 credits
the contruction will take 50 credits an hour
Time to build: 02:00:00

real example from game

building costs 292 credits
the contruction will take 55 credits an hour
Time to build: 5:18:33

Any idea on how to do this?
Status
Not open for further replies.
1 - 5 of 11 Posts
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
1 - 5 of 11 Posts
Status
Not open for further replies.