o all the people you can,
As long as ever you can.” - John Wesley
-
From: David Grugeon
To: "excel-macros@googlegroups.com"
Sent: Fri, February 22, 2013 7:23:40 AM
Subject: Re: $$Excel-Macros$$ Date hour valu
long as ever you can.” - John Wesley
-
From: David Grugeon
To: "excel-macros@googlegroups.com"
Sent: Fri, February 22, 2013 7:23:40 AM
Subject: Re: $$Excel-Macros$$ Date hour value problem!
OK
A date/
rting it become 2:03. Don't know why! Pls suggest!
>>>
>>>
>>> Sandeep Chhajer.
>>> Sent on my BlackBerry® from Vodafone
>>> --
>>> *From: * The Viper
>>> *Sender: * excel-macros@googlegroups.com
>>> *
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date hour value problem!
try this
If the value is in B3 use then formula
=(int(B3)+mod(B3,1)/.6)/24
then format as h:mm
Regards
David Grugeon
On 22 February 2013 20:36, The Viper wrote:
> excel will not hold a value as 2.30 with full decima
22 Feb 2013 15:48:08 +0530
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Date hour value problem!
>>
>> select the data and press ctrl+h
>> put .(dot) in "Find what" and put ":" in "Replace with&
excel-macros@googlegroups.com
> *Date: *Fri, 22 Feb 2013 15:48:08 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Date hour value problem!
>
> select the data and press ctrl+h
> put .(dot) in "Find what" and put ":&
ssage-
From: The Viper
Sender: excel-macros@googlegroups.com
Date: Fri, 22 Feb 2013 15:48:08
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Date hour value problem!
select the data and press ctrl+h
put .(dot) in "Find what" and put ":" in "R
select the data and press ctrl+h
put .(dot) in "Find what" and put ":" in "Replace with"
click Replace all
On Fri, Feb 22, 2013 at 3:41 PM, wrote:
> Dear excel guru,
> I have a problem...I want my hour to be written as 4:45. But I entered
> 2 data as 4.45. Now if I am changing it to [h]:mm f
Dear excel guru,
I have a problem...I want my hour to be written as 4:45. But I entered 2
data as 4.45. Now if I am changing it to [h]:mm format through custom format I
am getting 10:48 AM please help how can I convert it to 4.45 to 4:45.
Thanking you.
Sandeep Chhajer.
Sent on my BlackBerry®
