Convertin Decimals to clock time

[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

 

[JE McGimpsey]

One way:

= 1.23333/24

Format as h:mm

 

[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

 

[Trevor Shuttleworth]

Loretta

=1+14/60 = 1.23333333333333

=0.2333333333*60 = 14

Regards

Trevor