Support Board
Date/Time: Sun, 24 Nov 2024 15:06:02 +0000
Post From: How to measure current Trade time Duration via simple alert formula?
| [2024-05-31 13:43:35] |
| Sawtooth - Posts: 4118 |
|
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
|