Priyanka pls find the formula
After subtracting the two dates
Day()*24+hour()*60+min()
On Mar 23, 2014 12:45 AM, "Abhishek Jain" wrote:
> Yes, it will. As long as the dates and times are in correct format so as
> Excel reads them as values to allow subtraction, it will work. I just used
> simple
best way to calculate date difference.
using text function.
See in attached sheet.
Divaker
On Thu, Mar 27, 2014 at 2:25 PM, Priyanka Sachdeva <
priyanka.sachdeva...@gmail.com> wrote:
> Thanks All ! .. It worked
>
>
> On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar
> wrote:
>
>> Hi Priyanka,
>>
Thanks All ! .. It worked
On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar wrote:
> Hi Priyanka,
>
> PFA
>
>
> Thanks
> Ashish
>
>
> On 23 March 2014 17:35, Priyanka Sachdeva
> wrote:
>
>> Thanks Abhishek,
>>
>> Yes, I did see the formula. Never knew it would be that straight forward
>>
>> Will gi
Hi Priyanka,
PFA
Thanks
Ashish
On 23 March 2014 17:35, Priyanka Sachdeva wrote:
> Thanks Abhishek,
>
> Yes, I did see the formula. Never knew it would be that straight forward
>
> Will give it a try and keep you posted. Really appreciate the help !
>
>
>
> Regards,
> Priyanka S
>
>
> On Sun,
Well, I also had to read your email 6 times just to be sure that it is only
a plus-minus you were asking for :)
Do let me know if you need anything further in this.
Regards, Abhisek
On Sun, Mar 23, 2014 at 5:35 PM, Priyanka Sachdeva <
priyanka.sachdeva...@gmail.com> wrote:
> Thanks Abhishek,
Thanks Abhishek,
Yes, I did see the formula. Never knew it would be that straight forward
Will give it a try and keep you posted. Really appreciate the help !
Regards,
Priyanka S
On Sun, Mar 23, 2014 at 12:44 AM, Abhishek Jain wrote:
> Yes, it will. As long as the dates and times are in cor
Yes, it will. As long as the dates and times are in correct format so as
Excel reads them as values to allow subtraction, it will work. I just used
simple subtraction and set the format show only minutes. See 'Format Cell'
tab on the result for more clarity.
Regards,
Abhishek
On Sat, Mar 22, 201
Thanks a lot for the prompt response .. will give this a try
1 questions. Would this formula still work if the cell values are as below
Inception Date = 02-12-2014 10:26:12 AM (mm-dd-yyy hr:mm:ss)
Closure Date = 02-12-2014 10:29:00 PM
i.e it has a AM and PM instead of a 24 hour cl
Please see attached.
HTH
On Sat, Mar 22, 2014 at 7:16 PM, Priyanka Sachdeva <
priyanka.sachdeva...@gmail.com> wrote:
> Hello All,
>
> Am looking to calculate the difference in minutes between 2 dates. (
> Inception Date and Closure Date)
>
> Eg : Inception Date = 02-12-2014 10:26:12 (mm-dd-yy
Hello All,
Am looking to calculate the difference in minutes between 2 dates. (
Inception Date and Closure Date)
Eg : Inception Date = 02-12-2014 10:26:12 (mm-dd-yyy hr:mm:ss)
Closure Date = 02-12-2014 22:29:00
I need a formula to calculate the difference in minutes i between these 2
10 matches
Mail list logo
