Help with a time function

Hi, 

 

I am bit stuck on a time funciton. I have two times a1= start time and b1 = finish time.  C1 tells me the differnece in time as I have chanced the format.  This works fine.  In D1 I want to add a formula to show if C1 is over 24 hours. I have tried adding an if function =if(c1>24,1,0) but does not work.  I have scrolled Google but found nothing and then I have tried to ask a quesiton but everyone is trying to sell me something!  if you can help for free! Id really appriciate it!

 

Thanks in advance.

 

PaulCool

By: Paul Rhodes

Leave a Reply

Your email address will not be published. Required fields are marked *