rajkumar
06-21-2009, 12:21 PM
Hi,
I have written a custom function for calculating Uptime of Printers.
Function UpTime(StartDate, EndDate, NoOfMcs, DownTime)
UpTime = (Networkdays(StartDate, EndDate) * 8.5) * NoOfMcs - DownTime / (Networkdays(StartDate, EndDate) * 8.5)
UpTime = Application.Round(UpTime, 2)
End Function
Here iam getting an error "Sub or Function not defined" and the Networkdays is higlighted with Yellow Color
Can anybody help me to sort out this Error.
I have attached a sample workbook herewith.
Thanks in advance
I have written a custom function for calculating Uptime of Printers.
Function UpTime(StartDate, EndDate, NoOfMcs, DownTime)
UpTime = (Networkdays(StartDate, EndDate) * 8.5) * NoOfMcs - DownTime / (Networkdays(StartDate, EndDate) * 8.5)
UpTime = Application.Round(UpTime, 2)
End Function
Here iam getting an error "Sub or Function not defined" and the Networkdays is higlighted with Yellow Color
Can anybody help me to sort out this Error.
I have attached a sample workbook herewith.
Thanks in advance