Excell macro to calculate date differences
Closed
LenaR
-
Sep 23, 2011 at 03:36 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 23, 2011 at 05:20 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 23, 2011 at 05:20 AM
Related:
- Excell macro to calculate date differences
- Spell number in excel without macro - Guide
- How to calculate 90 days from date in excel - Guide
- How to change date format in excel - Guide
- How to calculate vat in excel - Guide
- How to calculate position in excel - Office Software Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 23, 2011 at 03:43 AM
Sep 23, 2011 at 03:43 AM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 23, 2011 at 05:20 AM
Sep 23, 2011 at 05:20 AM
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)))
Sep 23, 2011 at 04:17 AM