Try this formula in column C, and format column C as 24hr time:
=TIMEVALUE(LEFT(B2,LEN(B2)-2) & " " & RIGHT(B2,2))
Try this formula in column C, and format column C as 24hr time:
=TIMEVALUE(LEFT(B2,LEN(B2)-2) & " " & RIGHT(B2,2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks