put now() and in other cell input the number of hours in the same format and then add the two cells.
On Fri, Jan 30, 2009 at 8:38 AM, Muthu <psgmu...@gmail.com> wrote: > > > I will explain my problem with an example. > > 30/01/2009 13:30 is the time.I want to add 36 hrs to it. > > But I should add it only during the working hours.(8:30 hours per hour > a day(exclude week ends and holidays)). > > Assume working time to be from 08:00 to 16:30 > > So the time after 36hrs added would be 05/02/2009 16:00. > > > I can add only the date through workday function,which also excludes > holidays and weekends.But I am not able to add the exact time. > > Can YOU help me to get it done through macros?? > > Thanks in Advance > > > > -- Hari kumar --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
