Re: $$Excel-Macros$$ overtime calculation in excel

2010-08-30 Thread सुधीर इंगळे
Hi Vibhav Insert one colum "H" & put formula HOUR(G5)*60+MINUTE(G5) Regards Sudhir On Mon, Aug 30, 2010 at 11:39 AM, vaibhav joshi wrote: > Hi Sudhir > > Thank got your mail,but i want Total OT in Mnts,that is not getting > > Regards > > Vaibhav > > 2010/8/30 सुधीर इंगळे > > Vaibhav >> check

Re: $$Excel-Macros$$ overtime calculation in excel

2010-08-30 Thread vaibhav joshi
Hi Sudhir Thank got your mail,but i want Total OT in Mnts,that is not getting Regards Vaibhav 2010/8/30 सुधीर इंगळे > Vaibhav > check the attach file, > i think this will solve ur problem > > > Sudhir > > > On Mon, Aug 30, 2010 at 6:44 AM, vaibhav joshi wrote: > >> Hi all >> please find enclo

Re: $$Excel-Macros$$ overtime calculation in excel

2010-08-30 Thread सुधीर इंगळे
Vaibhav check the attach file, i think this will solve ur problem Sudhir On Mon, Aug 30, 2010 at 6:44 AM, vaibhav joshi wrote: > Hi all > please find enclosed sheet of overtime calculation. > Please note that duty timing is 6.30 to 4.30 > > If someone help me ,i will be grateful > > Regards >