Tech Support Guy banner
Cancel

converting value to time

974 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 - 1 of 11 Posts
T
You should be able to type into a cell 05:18:33 and press enter and it should automatically show it correctly.

If not, click on a blank cell, then select Format, Cells and then select the number Tab.

Under Category click on Custom
Then under type, scrolldown until you find the following format hh:mm:ss and then click on OK
When back in the cell you selected, type 05:18:33 and press enter
Save
Like
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
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top