I have time values listed as follows:
9:07:14 PM
5:26:35 PM
2:35:38 PM
7:41:28 AM
7:39:51 AM
7:38:40 AM
but they are not seen in excel as "excel time" (i.e., decimals)
How can I convert the above times correctly into decimals, or in other words into "excel time" values.
You could try....
=TIMEVALUE(cell-ref)
2 points I want to add...
1. Please change your location to more properly indicate where you are from. Members tailor formulas to take into account your regional settings (unless you consider Mississauga hell? lol)
2. If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks