Solved

Excel elapse time formula not working

Posted on 2011-09-07
3
211 Views
Last Modified: 2012-05-12
I have one spreadsheet that was sent back by experts exchange basically taking a start and stop time and creating an elapse time.  I have attached that spreadsheet.  I am trying to find the elapse time with new data but the formula doesn't work on a different spreadsheet.  I have attaced both spreadsheets here.  The one that works has an extra column showing the elapse time - the one that doesn't work does not have that column.  When I copied and pasted the new data into the old spreadsheet it does not calculate either.  I need to understand what I am doing wrong.  Escalation-Performance-August-ex.xls August-appt-ctr-stop-escalation.xls
0
Comment
Question by:lavita
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
peetjh earned 500 total points
ID: 36495260
At first glance your new sheet does have a different time zone so in the formula below you would need to replace EDT with CDT.

=IF(E3="","",(SUBSTITUTE(E3," EDT","")*1-(SUBSTITUTE(C3," EDT","")*1))*1440)
0
 

Author Comment

by:lavita
ID: 36495366
Having a blonde moment I guess - Thanks for the quick response - you guys are always great and I value my  membership - even when I ask stupid questions.  
0
 

Author Closing Comment

by:lavita
ID: 36923930
Sorry - I thought I had already closed this
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question