|
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users
| Upgrade on Time/Date Entry post – using TimeValue function- 2015-08-25 03:32:59-04 |
Suggested revised formula. A while ago I posted a blog post with a suggestion from a reader about how he quickly formatted batches of dates and times. He saw the post and came back with a revised formula – using TimeValue. He had originally suggested using =(LEFT(G2,1)&”:”&MID(G2,2,2)&”:”&RIGHT(G2,2)) to convert data such as 00514 to a time […]
Read more...
|
|