Time calculations in VBA

  • Thread starter Thread starter itsmaheshp
  • Start date Start date
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
+-------------------------------------------------------------------
 
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
 
Back
Top