Hi Experts,
Just need to compare two columns by last name . Will appreciate if you can
help me for this.
Satya.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexc
Dear Harkesh,
If you need a specific solution for your assignment or given data you can
consider attached file else look in to the solution given by kuldeep.
Rgds,
On Fri, Feb 22, 2013 at 10:14 PM, Harkesh Kumar
wrote:
>
>
>
> Please solve this Problem
>
>
>
> Please Seperate Special character
Assuming the first value is in A2
In B2 put =left(A2,1)
In C2 put =mid(A2,2,4)
Drag these formulas down.
Regards
David Grugeon
On 23 February 2013 16:14, Harkesh Kumar wrote:
>
>
>
> Please solve this Problem
>
>
>
> Please Seperate Special character and number
>
> num
>
> Ans
>
> @1234
>
>
Hey Paul, David thanks for your clarification. :)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Paul Schreiner
Sender: excel-macros@googlegroups.com
Date: Fri, 22 Feb 2013 04:59:54
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
your explanation is CLOSE!!
Excel date is the number of days since 1/1/1900
(or SINCE 31/12/1899, since 1/1/1900 is day (1) )
So, December 31, 1900 is actually day 366 (1900 was a Leap Year)
And... I suppose if it was actually taken as the number of days since the
beginning of TIME,
We'd probabl
OK
A date/time value is a number of days since the beginning of time
(31/12/1900 I think)
Time is a fraction of a day. so i hour is 1/24
My formula was =(int(B3)+mod(B3,1)/.6)/24
Lets take a value entered as 4.15 which we want to represent as 4:15 or 4
hours and 15 minutes.
Int(B3) gives us t
Hi,
I want unsubscribe form this group and send the mail in below mentioned
id but my mail not delivered in this id.
'macros+unsubscr...@googlegroups.com'
Request you to please unsubscribe ASAP.
Thanks!
Regards
Kailash
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Thanks David its working correctly. Can you please explain ! :)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: David Grugeon
Sender: excel-macros@googlegroups.com
Date: Fri, 22 Feb 2013 21:30:49
To: excel-macros@googlegroups.com
Reply-To: excel-macros@goo
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 decimal(2). We
> can derive the desired result by formula if you intend.
> share u
excel will not hold a value as 2.30 with full decimal(2). We can derive the
desired result by formula if you intend.
share us a sample file for more assistance
On Fri, Feb 22, 2013 at 3:53 PM, wrote:
> **
> Thanks for quick suggestion but it is not full proof where there is only 8
> is written i
Thanks for quick suggestion but it is not full proof where there is only 8 is
written it is not working. Again for strange reason where 2.30 was written
after converting it become 2:03. Don't know why! Pls suggest!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
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®
13 matches
Mail list logo
