Dear all, Attached is the sheet containing some Start Date, Start Time on the same Day and End Day, End Time of a particular activity. All viz. Start Date, Start Time, End Day, End Time are mentioned in the separate columns. Looking at the available data, I would appreciate if I can get help from you guys to - get me the difference in Time (Hours). As for instance, if my start day is 17-Feb-2010, Start Time is 12:00 Hrs, End Date - 18-Feb-2010, End Time is 15:00 Hrs, Hence, the formula required should be able to return Total Hrs as 27:00 Hrs in the succeeding column. Other option is to write date with Time in specified manner and directly deducting the same but the data available with me is as per the attached sheet and hence shall require more time to bring to that format. So, please consider as per attachment. Request you to please give your feedback on the same. With Regards, Aakash Sky Constructions Ltd, Mumbai.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
time sheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
