[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel elapse time formula not working

Posted on 2011-09-07
3
Medium Priority
?
219 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
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
JP earned 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

831 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