Can you tell me if the "time" in columns D and G represent actual time? or fractions of hours?
for example: Is 6.25 supposed to be 06:25:00AM or is 6-1/4 hours, which is 6:15:00AM ?? Paul ________________________________ From: Rajesh K R <rajeshkainikk...@gmail.com> To: excel-macros <excel-macros@googlegroups.com> Sent: Mon, March 7, 2011 11:22:53 AM Subject: $$Excel-Macros$$ Calculate Time Hi Experts , Kindly check the attached file and tell how to calculate the hours of stay in column "I". Regards Rajesh kainikkara -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
