Tech Support Guy banner
Cancel

converting value to time

978 Views 10 Replies 4 Participants Last post by  Zack Barresse, 
Couriant
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?
Save
Like
Status
Not open for further replies.
1 - 4 of 11 Posts
Zack Barresse
Example:

100 in A2
50 in B2
=(A2/B2)/24 in C2

50 in A3
100 in B3
=(A3/B3)/24 in C3 (or copied down from above.

Format column C as "[hh]:mm:ss" (w/o quotes)

Sample file is uploaded.

Attachments

See less See more
Save
Like
Zack Barresse
Credits? Unless it's a good FPS or FF, count me out. :D
Save
Like
Zack Barresse
Conditional Formatting, under the Format menu I believe. You only have 3 conditions though, unless you pre-format your cell to one specific (default) condition, then you have four. More than that requires VBA.
Save
Like
Zack Barresse
Then use the Formula Is portion. Be sure to note the active cell when you do this and the references you use, as they are related. So if you have A1 selected and your formula is "=A2=1", then you copy cell A1 to B1, then check the CF of B1, the formula should read "=B2=1". You can use absolute and relative in CF.

HTH
Save
Like
1 - 4 of 11 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top