Bound4Glory
New Member
- Joined
- Jun 21, 2020
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Hello,
I'm trying to flag an item with time out greater than 6 hours. I'm struggling to get the correct answer, I believe my issue is with time value since excel stores it in decimal form.
Thanks in advance
I'm trying to flag an item with time out greater than 6 hours. I'm struggling to get the correct answer, I believe my issue is with time value since excel stores it in decimal form.
COLUMN A | COLUMN B | COLUMN C |
TIME OUT | CURRENT TIME | FLAG |
01/21 05:48 | =NOW() | =IF(B2-A2>6,"MISSING","OK") |
Thanks in advance