Computing Elapsed Time
I am working with W XP and Excel 2003.
Column A contains a start date Column C contains an end date The date columns are in the mm/dd/yy format The end date will either be equal to the start date or greater than the start date Column B contains a start time Column D contains an end time The time columns are in the hh:mm format and the hh portion is in 24 hour format The end time will always be later than the start time IF the start Date and End Date are the same. If the end date is after the start date the end time can be anything. What I need is a formula to compute the hours and minutes between the combined start date and time and the combined end date and time. Thanks for any and all help. |
Computing Elapsed Time
wrote:
Column A contains a start date Column C contains an end date [....] Column B contains a start time Column D contains an end time What I need is a formula to compute the hours and minutes between the combined start date and time and the combined end date and time. =(C2+D2)-(A2+B2) formatted as Custom [h]:mm . The [h] form displays hours greater than 24, if appropriate. |
Computing Elapsed Time
On Monday, November 12, 2012 11:42:05 PM UTC-5, wrote:
I am working with W XP and Excel 2003. Column A contains a start date Column C contains an end date The date columns are in the mm/dd/yy format The end date will either be equal to the start date or greater than the start date Column B contains a start time Column D contains an end time The time columns are in the hh:mm format and the hh portion is in 24 hour format The end time will always be later than the start time IF the start Date and End Date are the same. If the end date is after the start date the end time can be anything. What I need is a formula to compute the hours and minutes between the combined start date and time and the combined end date and time. Thanks for any and all help. Thanks for your reply. Your solution works for those situations that occur over a short period, say 1 day. Over a multiple day situation it is giving me a problem. The period between 10/29/12 19:33 and 11/8/12 15:40 gives me an elapsed time of 20:07. Also when I sum up the elapsed time column I do not get a meaningful value. |
Computing Elapsed Time
On Monday, November 12, 2012 11:42:05 PM UTC-5, wrote:
I am working with W XP and Excel 2003. Column A contains a start date Column C contains an end date The date columns are in the mm/dd/yy format The end date will either be equal to the start date or greater than the start date Column B contains a start time Column D contains an end time The time columns are in the hh:mm format and the hh portion is in 24 hour format The end time will always be later than the start time IF the start Date and End Date are the same. If the end date is after the start date the end time can be anything. What I need is a formula to compute the hours and minutes between the combined start date and time and the combined end date and time. Thanks for any and all help. Claus & Joel, Thanks for your help. I'm in good shape thanks to you. |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com