Convertin Decimals to clock time

  • Thread starter Thread starter Loretta
  • Start date Start date
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
 
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
 
Back
Top