Time calculations in VBA

I

itsmaheshp

here is the situation actually.plz find the attachment.
when u click on cell 'N50' it displays 0.7500000 instead of 0.75 an
0.999999.. instead of 1.
the code which i have written for this is in modul
Valudation.chkHrs()
plz solve this.
thanks & regards,
Mahes

+-------------------------------------------------------------------
|Filename: Offline-TMS1.zip
|Download: http://www.excelforum.com/attachment.php?postid=2774
+-------------------------------------------------------------------
 
M

mangesh_yadav

WHat is being displayed in the cell is a different matter. As for th
VBA code which you had given, you need not use CInt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time calculations in VBA 1
Add custom tool tip to a Point in Scatter chart using VBA 1
Calculating the difference between hours 1
Stacked Column VBA 1
import array text to row data in excel 2
"Invalid Property" msg when Property Valid??? 1
Auto cell range calculations 2
problem using VBA in Excel 1

Top