Comparing 2 dates and times

  • Thread starter Thread starter bollard
  • Start date Start date
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
 
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
populate month-yyyy when compare 2 cells 3
to CONCATENATE from the smallest date with at least 2 criteria 17
Time/priority problem 2
date and time difference 19
Date/Time 1
Adding Days and Hours 8
separating date and time 5

Back
Top