Detect if over 24 hours

**danfullwood** · 06-04-2014, 08:13 AM

Hello,

I need a formula which will detect if the closed time is under or over 24 hours of the opening time. If it is over 24 hours, i need it to say Fail, if under then say Successful

An example of what i require is attached.

EXAMPLE.xls

Thank You

**Ace_XL** · 06-04-2014, 08:15 AM

In E2

=IF((C2+D2)-(A2+B2)<1,"Successful","Fail")

Copy down

**danfullwood** · 06-04-2014, 08:32 AM

Thank You for your help ACE_XL

Detect if over 24 hours

LinkBack

Thread Tools

Rate This Thread

Display

Detect if over 24 hours

Re: Detect if over 24 hours

Re: Detect if over 24 hours

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours

[SOLVED] Formula Calculated total work hours - now need to remove breaks and standard hours?

[SOLVED] Calculate hours with predefined Working Hours and Weekend Hours

Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

Bookmarks

Bookmarks

Posting Permissions