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
Dear Sir,
I want following in an excel file
1) One User with administrative rights.
2) One User who can only do data entry deletion not allowed
3) One User who can only view the sheet neither made entry nor make changes.
4) When data entry user make any changes and save the file at a time the
Ashish Sir,
you are really Great...
i am very big fan of you..
thank you so much for the providing the code, this is working good.
On Saturday, 22 March 2014 11:38:08 UTC+5:30, ashish wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Sub create()
>
>
> Dim wk As Worksheet, wk2 As Worksheet
> Dim
