I'm looking for a formula that adds a colon to military time if the user hasn't entered one.
So B1 would have a formula that if A1 = 1113, B1 = 11:13, and if A1 = 11:13, B1 = 11:13
I'm looking for a formula that adds a colon to military time if the user hasn't entered one.
So B1 would have a formula that if A1 = 1113, B1 = 11:13, and if A1 = 11:13, B1 = 11:13
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks