Hi all
I want to insert a particular data into a cell via VBA code. This is my code:
Cells(ActiveCell.Row, "D").NumberFormat = "[h].mm.ss"
Cells(ActiveCell.Row, "D") = "8.3" '8 hours and 03 minutes
Why after executing this code the cell contains 199.12.00 and not 8.03.00?
Please help!
PS: if i enter manually '8.3', excel correctly format cell as '8.03.00'...
You would use:
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
THXX!!! Works fineOriginally Posted by Domski
But I don't understand why if I type 8.03 in the sheet excel format the cell in the right way.
Times in Excel are stored as decimal fractions with one hour being the equivalent of 1/24 so Excel is interpreting 8.3 as being the equivalent of 199.2 hours.
Dom
Last edited by Domski; 07-15-2011 at 05:52 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks