mattster1010
06-23-2008, 06:48 AM
Good Afternoon,
I have three columns, A,B & C, I have used the following formula to calculate the difference in hours and minutes bewteen the two dates listed in columns A and B (total is shown in C)
=TEXT(B2-A2,"h:mm")
this returns the example below:
A B C
16-06-2008 10:32:00.016-06-2008 11:22:00.00:50
I what to create a formula that will return a 'YES' for a value less than 24 hours and a 'NO' for a value greater than 24 hours. This formula will be based on the total of column C.
Can any one help / point me in the right direction please.
Cheers,
Mattster
I have three columns, A,B & C, I have used the following formula to calculate the difference in hours and minutes bewteen the two dates listed in columns A and B (total is shown in C)
=TEXT(B2-A2,"h:mm")
this returns the example below:
A B C
16-06-2008 10:32:00.016-06-2008 11:22:00.00:50
I what to create a formula that will return a 'YES' for a value less than 24 hours and a 'NO' for a value greater than 24 hours. This formula will be based on the total of column C.
Can any one help / point me in the right direction please.
Cheers,
Mattster