Login Page - Create Account

Support Board


Date/Time: Mon, 07 Jul 2025 01:13:56 +0000



Post From: ZigZAG time duration in spreadsheet

[2014-11-02 19:14:12]
Sawtooth - Posts: 4236
You can calculate it with these formulas:
O3:
=IF(AC3>0,A3,O4)
P3:
=IF(O3>O4,O3-O4,"")
where 'Additional Output for Spreadsheets' is Yes, and column AC is the Reversal Price.

However, you cannot display the value in Time format.