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.

im not an expert but cant u just format the cell to display time?

Unfortunately, I can't find a code to do that.

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.

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

!! Thanx!