I need help on working with  an existing formula that I have a total of minutes  that are added up for certain  time frames, and I do get the totals for these rooms, but if the total is greater than 60 minutes it should default to "0", and this is where I am stuck.

 

My current formula is

 

IF {Field name} = PREVIOUS ({Field Name}) and {Field DATE}= PREVIOUS ({Record Field DATE}) THEN
((TIME({ENTERED_ROOM}) - TIME(PREVIOUS
({CaseEXIT_TIME})))/60) else 0;

 

I am trying to  get the total time over 60 minutes to default to 0.

 

Any ideas?

 

Thanks

Bee