Date -time subtraction..

sunny2u86 Posts 14 Registration date Thursday February 2, 2012 Status Member Last seen June 4, 2012 - Jun 2, 2012 at 10:40 AM
 Blocked Profile - Jun 4, 2012 at 06:01 AM

hi again,need help i need a macro that will subtract date-time in column A with the Present Date-time and display the value as number of days..
(Sample Calculation performed at 6/1/2012 21:00)

6/1/2012 21:44-----------------0
6/2/2012 12:42-----------------1
6/3/2012 08:44-----------------1
6/5/2012 20:44-----------------2
2/1/2012 22:32-----------------126
5/3/2012 11:11-----------------35

Values in column A can vary so calculation is dome according to it..


2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 4, 2012 at 05:54 AM
suppose data is A1 to B6

in C1 type this formula
in D1 type this formula
highlight c1 and d1 and copy them down
Blocked Profile
Jun 4, 2012 at 06:01 AM

Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.