I have a number in a cell (42340.6340277778) formatted like this: mm/dd/yy hh:mm
I would like to keep the number in the date&time format that it's in, and output just 0.6340277778 into another cell. How can this be done with VBA?
Thanks
I have a number in a cell (42340.6340277778) formatted like this: mm/dd/yy hh:mm
I would like to keep the number in the date&time format that it's in, and output just 0.6340277778 into another cell. How can this be done with VBA?
Thanks
Last edited by luv2glyd; 12-03-2015 at 03:18 AM.
You either quit or become really good at it. There are no other choices.
Not sure of the VBA for this, but the fornmula would be...
=MOD(A23,1) Format as Time
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
Please Login or Register to view this content.
Assume your data in column A. Results in column B. Here is a VBA solution
Option Explicit
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Great! Thank you everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks