Comparison operator with duration that may exceed 1 day with format h mm

0 votes

I have an excel spreadsheet that tracks duration, which can range from 0:00 (h:mm) to d:h:mm (with number of days beyond 1). Up to column T, "Respect Délai," everything goes according to plan. Here, I want to determine whether the deadline (délai) is honored using the following formula:

 =IF(OR(AND(S2="1:00",D2="Imagerie Conventionnelle"),AND(S2="5:00",D2="Imagerie lourde")),"Oui","Non") 

where column D denotes a binary kind of imagery (must remain the same) and D denotes a duration in the format h: mm (that sometimes goes beyond 23:59). The formula appears to work for most of the rows, but for others, it returns the wrong answer based on the IF conditions (I manually confirmed them), and I'm not sure why.

Please note that I tried to use the TIME(h,,) instead of "h:mm" but since it only accepts values between 0:00 and 23:59, this doesn't seem to work either.

Mar 25, 2023 in Others by Kithuzzz
• 38,010 points
197 views

1 answer to this question.

0 votes

Try this:

=IF(OR(AND(S2<=0.0417,D2="Imagerie Conventionnelle"),AND(S2<=0.2083,D2="Imagerie lourde")),"Oui","Non")
answered Mar 25, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

Flutter Error: MediaQuery.of() called with a context that does not contain a MediaQuery.

Hi@akhtar, You need a MaterialApp or a WidgetsApp around your widget. They ...READ MORE

answered Aug 27, 2020 in Others by MD
• 95,440 points
4,811 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
1,274 views
0 votes
0 answers

Download Excel sheet from .NET Core 3.1 Web API with jQuery Ajax client

I am trying to download an Excel ...READ MORE

Feb 10, 2022 in Others by Edureka
• 13,670 points
934 views
0 votes
1 answer

Expected response code 250 but got code "530", with message "530 5.7.1 Authentication required

Your mail.php on config you declare host ...READ MORE

answered Feb 16, 2022 in Others by Aditya
• 7,680 points
2,349 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,164 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,393 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
686 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,266 views
0 votes
1 answer

How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,420 points
3,032 views
0 votes
1 answer

Rich text format (with formatting tags) in Excel to unformatted text

This function ought to be helpful if ...READ MORE

answered Oct 20, 2022 in Others by narikkadan
• 63,420 points
1,350 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP