Prev: Need to copy and match data from one workbook to another workbook
Next: Disabling "cut" function - version 2003/2007
From: Garreth Lombard on 7 Apr 2010 04:17
Chinared,

Please use this formula to get a more accurate answer to indicate the hours
and minutes. However, if you want to display the :14 as seconds then you
should use a "." instead of a ":" in your question.

=INT(A1/60)&":" &MOD(A1,60)
--

Thank you and Regards

Garreth Lombard


"Fred Smith" wrote:

> A1= 115:14
> Hours: =a1*24
> Format as a number
>
> In the future post your question in this space, as it is only a small subset
> of people who can reply to a subject-only message.
>
> Regards,
> Fred
>
>
> "Chinared" <Chinared(a)discussions.microsoft.com> wrote in message
> news:7C2D847B-7CC0-40F4-BDFC-2FC313C23380(a)microsoft.com...
> >
>
> .
>
 | 
Pages: 1
Prev: Need to copy and match data from one workbook to another workbook
Next: Disabling "cut" function - version 2003/2007