Subtract a Date/Time

Solved/Closed
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Feb 11, 2010 at 03:41 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 11, 2010 at 07:11 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 11, 2010 at 07:11 AM
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
0