Thread
:
Time format help needed
View Single Post
#
6
Ben McBen
Posts: n/a
Another alternative is to use an adjacent cell to do the
conversion for you (this may not be acceptable). You
can use a formula thus:
=TIMEVALUE(LEFT(D5,2)&":"&RIGHT(D5,2))
where D5 contains your number.
Reply With Quote