[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel elapse time formula not working

Posted on 2011-09-07
3
Medium Priority
?
217 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:
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

656 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