I'm looking for a way to convert a column of cells with military time in them to standard time. They do not have a colon in them so when I try to format cells to time, it does not work. Please see attached sheet. Col A has the orig times, Col C has the desired revisions. Any suggestions?
Here is one way, I'm sure there is a better way.
This looks at the numbers in Col A and put the time in Col B
Please Login or Register to view this content.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
Or in C1 and copy down,
=dollarde(A1/100,60)/24
and format as you wish.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks