Login Page - Create Account

Support Board


Date/Time: Sun, 11 May 2025 14:40:20 +0000



Post From: ZigZAG time duration in spreadsheet

[2014-11-02 19:14:12]
Sawtooth - Posts: 4214
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.