anytime

Hello, I am brand new to excel and need some assistance on how to enter a formula that will calculate the percentage of how many days a week an employee clocked in at 10:05am and anytime before that. <tbody> May 05/01/19 10:06 05/02/19 10:05 05/03/19 10:11 </tbody> <tbody>...

i am trying to write a formula to return my value with request: #1 ) if cell B2 value is "full", return with "anytime" in C2 #2 ) if cell B3 value is "0", return with ""(leave it blank) in C3 #3 ) if cell B4 value is contain "0:00", return with the original value in C4 actually i want to use...

Thank you for your help, I understand the break lines now are char(10) and ctrl-J So if i have in one cell the following <tbody> John Smith 123 Main street Mycity, 123445555 </tbody> So if I want name and address and city in different columns then I use text-2-columns and the delimiter is...

Hello Friends, <colgroup><col><col><col><col><col><col><col span="7"></colgroup><tbody> I am trying to find if any of the values in a range cell matches to any value in another another range of cell.One cell range has fixed value another cell range keeps changing constantly. I need to write a...