Looking for an IF formula which prints YES if more than 6 hours and NO if less than 6

**luisvv93** · 08-08-2018, 01:47 PM

Hello Team,

I have the following data:

Assigned Date
2018-08-08 10:04:38AM GMT-0700
2018-08-07 11:49:25PM GMT-0700
2018-08-08 01:07:04AM GMT-0700
2018-08-08 01:24:05AM GMT-0700
2018-08-07 06:41:12PM GMT-0700
2018-08-08 06:52:36AM GMT-0700

and a lot more of them, I need to know if there are more than 6 hours from that date until today hour( let's say 08/08/2018 11:00AM), is there anyway to do that with that information "Assigned Date" row.

Thanks in advance,
Luis V.

**Sam Capricci** · 08-08-2018, 02:11 PM

are your "assigned dates" actual times/dates or are they text?
if they show up as times/dates then =IF(NOW()-A2>0.25,"YES","NO") should work assuming your assigned dates begin in cell A2.

**luisvv93** · 08-08-2018, 06:05 PM

Thank you for your answer, and they are text, so I dont think that formula will work

Is there a way to convert that to date or maybe another formula ?

Thank you

**Zer0Cool** · 08-08-2018, 06:24 PM

Presuming that all your entries are the same length (yyyy-mm-dd hh:mm:ssAM/PM GMT...) then you can pull the parts out as their positions are known and then rebuild them into time/date values.

Assume you have a time/date like you posted in A2:

Extract Date from string (format cell with the formula as date) (2 examples, use either or, not both)

Formula:

Please Login or Register  to view this content.

Extract time from string (format cell as desired time format with the formula in it) (2 examples, use either or, not both)

Formula:

Please Login or Register  to view this content.

You can simply add the results of both or combine them into a single formula:

Formula:

Please Login or Register  to view this content.

This should resolve the issue of not having actual date/time values, in which case the previous suggestion should work.

**luisvv93** · 08-10-2018, 11:29 AM

It worked perfect!! Thank you very much!!

Looking for an IF formula which prints YES if more than 6 hours and NO if less than 6

LinkBack

Thread Tools

Rate This Thread

Display

Looking for an IF formula which prints YES if more than 6 hours and NO if less than 6

Re: Looking for an IF formula which prints YES if more than 6 hours and NO if less than 6

Re: Looking for an IF formula which prints YES if more than 6 hours and NO if less than 6

Re: Looking for an IF formula which prints YES if more than 6 hours and NO if less than 6

Re: Looking for an IF formula which prints YES if more than 6 hours and NO if less than 6

Thread Information

Users Browsing this Thread

Similar Threads

vba Prints FALSE in cell instead of Formula

IF formula which prints YES if function is true.

Formula for link that automatically prints another tab in same workbook when clicked?

formula/function that prints only positve numbers

[SOLVED] How do write a formula so that only rows with info prints?

3 pg excel wrksht,pg 2 prints formula answers,insert pic behind

a loop formula that filters and prints?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions