Subtract a Date/Time

Solved/Closed
Gouws Posts 45 Registration date Sunday 7 February 2010 Status Member Last seen 15 April 2012 - 11 Feb 2010 à 03:41
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Feb 2010 à 07:11
Hello,
Can anyone help me with a formula in excel 2007 to subtract eg 11/01/2010 5:12 AM from 15/01/2010 7:30 PM.

Thanks
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
11 Feb 2010 à 07:11
If both are dates then you can use a1-b2 simply. When I say both are dates, I mean to say that excel treat them as dates and they are not just text that looks like dates