Value 1 in date/time means a day. So 100/50 = 2 days. Divide it by 24 to get hours. Format the cell to show properly.
converting value to time
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?
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 - 1 of 11 Posts
1 - 1 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
