I need to subtract time and date in differnt cells, for example A1= Date B1= Time A2=Date B2=Time Now, i require to time duration between A1 B1 and A2 B2.
Reply from Richard Rost:
Just add A1 and B1 to get the date/time. Then subtract the two resulting cells to get the difference.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.