Blipo Posted October 9, 2005 Share Posted October 9, 2005 Ok... so I made a calculator of sorts for the OoC, run of Excel. It's pretty cool, but has one problem: It displays times in decimals. Ex/ Displays 1.5 should display 1.3, or 1:30, or something (as in - 1 hour 30 minutes) In case it helps, I have a nice pic here for going from time to decimal, but not the other way around... Help...? Oh and if you could come up with a math formula that converts them, that works, too. Link to comment Share on other sites More sharing options...
prostar Posted October 10, 2005 Share Posted October 10, 2005 im not an expert but cant u just format the cell to display time? my rsn is Prostar Link to comment Share on other sites More sharing options...
Blipo Posted October 10, 2005 Author Share Posted October 10, 2005 Unfortunately, I can't find a code to do that. Link to comment Share on other sites More sharing options...
____ Posted October 11, 2005 Share Posted October 11, 2005 right click the cell and go into 'format' or whatever. And somewhere in there should be the option to set it to 'time' or whatever. i gotta leave now - so meh. check better when i get home. Link to comment Share on other sites More sharing options...
fullup Posted October 11, 2005 Share Posted October 11, 2005 If your decimal time is in cell A1 then try =CONCATENATE(TEXT(INT(A1),"00"),":",TEXT((A1-INT(A1))*60,"00")) if you want the result as text, or =TIME(INT(A1),(A1-INT(A1))*60,) if you want it as a time data type Link to comment Share on other sites More sharing options...
Blipo Posted October 11, 2005 Author Share Posted October 11, 2005 !! Thanx! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now