Time calculations in VBA
 

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
+-------------------------------------------------------------------

--
itsmahesh
-----------------------------------------------------------------------
itsmaheshp's Profile: http://www.excelforum.com/member.php...fo&userid=1585
View this thread: http://www.excelforum.com/showthread.php?threadid=27689

Time calculations in VBA
 

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

--
mangesh_yada

-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27689