Support Board

Date/Time: Wed, 03 Jul 2024 01:45:57 +0000

Post From: How to measure current Trade time Duration via simple alert formula?

[2024-05-31 13:43:35] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4036
when I subtract J41-J42, I get a very small fractional value The actual value is not important because they are SerialDateTime values and can be very small. For example: 1 second = 1/86400 = 0.000011574074074074073 1 minute = 1/1440 = 0.0006944444444444445 1 hour = 1/24 = 0.041666666666666664 Spreadsheet Example Formulas and Usage: Using Date Time So you are comparing a very small decimal value to another very small decimal value, e.g.: =AND(J8<>0,J41-J42 >= 5/1440) Is there a way (or a need) to isolate just the time component of what's in those cells? There is no need, but you could if you want to: =AND(J8<>0,FRACTIME(J41)-FRACTIME(J42) >= 5/1440) Edit: You don't want to if your trade duration crosses midnight. Date Time Of Last Edit: 2024-05-31 16:25:57