I am currently using a time card on google sheets
I have the clock in and outs,

I am currently using a time card on google sheets
I have the clock in and outs, although the formula i have only generates 24 hour period. I need the formula adjusted to generate the hours worked if they worked past 12am.
See the top formula and help me plus in tn what ever is needed to adjust it so it does not say NA
Please see attachment.