Comparing Date and Time

  • Thread starter Thread starter brianc0428
  • Start date Start date
B

brianc0428

I would like to be able to compare the date and time in G1 (Dat
Entered) with the date and time in L1 (Date Received) and have
M1 (SLA) reflect if the SLA was met or missed. So, if the Date entere
is no more than 24 hours after the date received then the SLA is met
If it is after the 24-hour period, then it's “Missed”. How would I g
about doing this?

Any help is appreciated.

Thanks in advance.
Bria

Attachment filename: test report.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56427
 
Try the following:

IF(INT*((L1-G1)*24)>24,"MISSED","MET")

Hope this helps, and remember that using CTRL+; will
always hardcode now's date and time.

Regards
Niall
 
I would also add conditional formatting to the target cell so as to emphasis
a missed SLA.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top