Need help with time calculations
I am creating a case log database for anesthesia providers. I'm trying to perform time calculations such as duration of anesthesia after inputting start and end time. Occasionally, we must pause anesthesia time. I have pause and resume anesthesia time. Is it possible to create a script that will account for all these variables to calculate a total time? There would be some instances where the pause and resume are not populated (only start and end). I'm very new to Filemaker, so detailed instructions would be greatly appreciated.