How to get Turn-Around-Time (TAT) in dealing with "Blanks"

[Anonymous]

Hi Kind People,

I hope you can help me with these. I'm trying to get the TAT of my data.

1. if Date and Time Accomplished is 'Blank', don't get or include the TAT for this

here's the sample data below,

Date and Time Received	Date and Time Accomplished	TAT
Mon 1/23/2023 9:16 PM	1/23/2023 21:41
1/23/2023 1:58am
1/23/2023 16:23	1/23/2023 16:25
1/23/2023 8:49	1/23/2023 9:06
1/23/2023 8:02	1/23/2023 9:03
1/23/2023 7:53	1/23/2023 8:04

[FreemanZ · Accepted solution]

hi @Anonymous 

are you expecting something like this:

TAT = 
VAR _tat =FORMAT(    [Date and Time Accomplished] - [Date and Time Received], "h:m:s")
RETURN
IF(
    [Date and Time Accomplished]<>BLANK(),
    _tat
)

[Anonymous]

Yeyyy!! This works FreemanZ! thank you very much, God bless!