Calculating time between two dates

[techstyle20]

Hi,

I need to calculate an SLA.

I have 1 column called 'Date/Time Requested' containing the time and the date together, as in:

dd/mm/yy hh:00

I also have a second column called 'Date/Time Completed' containing the date and time in the same format as above.

I need a macro that compares the two and works out the following:

< 48 hours = "Within SLA"
> 48 hours = "Outside SLA"

Thanks in advance.

 

[techstyle20]

Sorry the time and date format reads like

dd/mm/yy hh:mm

 

[shg]

How about just a formula?

=if(count(a1:b1) < 2, "", if(b1-a1 < 2, "Within SLA", "Outside SLA"))

 

[techstyle20]

Sorry,

I also need it to take weekends and holidays into account.

 

[VoG]

Try

=IF((B1-A1)*24<48,"Within SLA","Outside SLA")