Convertin Decimals to clock time

L

Loretta

I need to convert 1 hour &.233333 of an hour into clock time. I.e. 1 hour 14
minutes. Does any one have the formula or know what function does this.
Loretta
 
F

Frank Kabel

Hi Loretta
how is the value stored (e.g. 1.23333 or with text in between as shown
in your example). If it's stored as decimal number try
=A1/24
where A1 stores the value and convert this target cell as time
 
T

Trevor Shuttleworth

Loretta

=1+14/60 = 1.23333333333333

=0.2333333333*60 = 14

Regards

Trevor
 
Top