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
4479
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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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