Excell macro to calculate date differences
Closed
LenaR
-
23 Sep 2011 à 03:36
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Sep 2011 à 05:20
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Sep 2011 à 05:20
Related:
- Excell macro to calculate date differences
- Formula to calculate vat in excel - Guide
- How to change date format in excel - Guide
- Excel online macro - Guide
- Vba calculate - Guide
- How to run a macro in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
23 Sep 2011 à 03:43
23 Sep 2011 à 03:43
You said in this format . So what answer you expect in this case
October 1, 2010 8:00:00 AM GMT+03:00
October 1, 2010 9:00:00 AM GMT+03:00
October 1, 2010 8:00:00 AM GMT+03:00
October 1, 2010 9:00:00 AM GMT+03:00
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
23 Sep 2011 à 05:20
23 Sep 2011 à 05:20
Depending on how u want to use it, one option would
to covert to date
=DATEVALUE(LEFT(A1, FIND(" GMT",A1))) + TIMEVALUE(LEFT(A1, FIND(" GMT",A1))) - DATEVALUE(LEFT(A2, FIND(" GMT",A1))) + TIMEVALUE(LEFT(A2, FIND(" GMT",A2)))
to covert to date
=DATEVALUE(LEFT(A1, FIND(" GMT",A1))) + TIMEVALUE(LEFT(A1, FIND(" GMT",A1))) - DATEVALUE(LEFT(A2, FIND(" GMT",A1))) + TIMEVALUE(LEFT(A2, FIND(" GMT",A2)))
23 Sep 2011 à 04:17