caculated time

[thongho]

help me with this problem . [Time Out] < [Start Break 1], [Time Out] - [Time In] is true but why it always show TRUE,[Time Out]-[Time In]-[break time]

ifs(
isblank([Time Out]),"",
[Time Out] < [Start Break 1], [Time Out] - [Time In],
AND([Time Out] > [Start Break 1], [Time Out] < [End Break 1]),[Start Break 1] - ("1970-01-01 " & TEXT([Time In], "HH:mm:ss")),
TRUE,[Time Out]-[Time In]-[break time]
)

[Marc_Dillon]

So you're trying to calculate a work duration, time out minus time in minus breaks, right? What are the column types? What are some data examples? Why would [time out] ever be less than [start break 1] ? Why would [time out] ever be between [start break 1] and [end break 1]? Why can't you just always use [time out]-[time in]-[break time] ?