Hi Max!
Not working for me.
The formula is returning the decimal equivalents and when formatted as TIME
13:30 displays as TIME AM
1:43
9:52
3:17
If I add 12 hrs it works!
Biff
"Max" <[email protected]> wrote in message
news:[email protected]...
> Assuming the decimals are in A1 down
>
> Put in B1:
>
> =IF(OR(A1={0,24}),0,LEFT(A1,SEARCH(".",A1)-1)/24+MID(A1,SEARCH(".",A1)+1,2)/
> (24*60))
>
> Format B1 as Time, Type:"13:30", and copy down
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Steved" <[email protected]> wrote in message
> news:[email protected]...
>> Hello from Steved
>>
>> 1.43 to 1343
>> 9.52 to 2152
>> 3.17 to 1517
>> I have the above in decimal please a formula to 24hour clock as above
>>
>> ie 3.17 to become 1517 not 15.17
>>
>> Thankyou
>
>
Bookmarks