| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Computing Time from One Day to Another | Excel Discussion (Misc queries) | |||
| Macro elapsed time bar (same as download time elapsed bar) | Excel Programming | |||
| Formula for computing day of the week and time | Excel Worksheet Functions | |||
| Computing Date n time | Excel Programming | |||
Threaded Mode
