Just want to make sure, you’re trying to “format” the time only, and not trying to convert that to your local time, is it correct?
I don’t think the time that is written to the Login sheet carries any timezone information. Please correct me if I’m wrong.