Comparing 2 dates and times

B

bollard

Hi

I have a spreadsheet with 5 columns:

A = date an e-mail received
B = time e-mail received on that date
C = date e-mail replied to
D = time e-mail replaied to on that date e-mail
E = was the e-mail replied to within agreed time limit?

The agreed time limit is 24 hours.

I'd be happy enough coming up with a formula to input Y or N into colmun E,
if I only knew how to subract a time AND date from another time and date.

Can anyone advise, please?

Many thanks.

Keith
 
B

bollard

Hi David

Many thanks for this, but can you tell me what format the respective columns
need to be in so that this formaula will work?

Cheers.

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating difference between times on 2 dates 4
Time/priority problem 2
calculate total hours based on dates 5
Calculating networkdays & working hours 4
Adding Days and Hours 8
How do I find elapsed time between 2 dates and times? 5
Comparing Date and Time 4
Problems with Mail Merge and Dates 3

Top