Thread: [Solved] Calculate Average Time Elapsed in Days, hours and minutes
View Single Post
 
Old 09-08-2015, 05:52 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The formula you're using returns a result that is text, not a number, which makes it very difficult to do any further calculations with it. Besides which, there is no such thing as a standard 'month', so you can't just divide the number of days by a constant and expect a reliable result. That said, you could use the DATEDIF function to express the number of days as calendar months - but only if you have both the starting date and the end date to which the number (2291.07 - which is actually more than 8.6 years) relates.

Since none of the data from your first post spans even one week, it's difficult to understand what it is you're having issues with on that score. Perhaps you should attach a workbook to a post with some representative data. You can do that via the paperclip symbol on the Advanced posting menu.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote