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.
By: Paul Rhodes