Elapse Time greater than or equal 4 hours, 8 hour, 72, hours and 168 hours

[dubT75]

Hey Guys/Gals,

Trying come up with a simple formula that assigns a yes or no value to elapse times of 4 hours, 8 hour, 72 hours and 168 hours.

My best guess was if=(cell)<=[timehack], "yes", "no"

1. I'm not sure if I'm even close

2. if I am close how do I show the correct time hack ex. 4 hours = 04:00:00(h:mm:ss)?

*background - we're reporting SLA compliance for p1 = <4 hours, p2 <8 hours, p3 <72 hours etc



Thanks
DubT

 

[arthurbr]

4 hours is actually 0.1666667 (=4/24)
You can also use the TIMEVALUE function