Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default Can you calculate delta time using different entries

Hi,

It's done by subtraction

=B1-A1
Format as H:MM:SS
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Ed" wrote:

I import information into excel that includes a timestamp in hh:mm:ss AM/PM
format. Is there a way to caluclate delta time between different events?
Thanks in advance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare two sheets, identify values, calculate delta - Pls help Hannes Excel Programming 7 August 7th 08 09:55 PM
Calculate Ending time using Start Time and Elapsed Time Chief 711 Excel Worksheet Functions 5 May 13th 08 04:34 PM
find the same entries and calculate sum Alex Excel Worksheet Functions 8 March 24th 06 11:25 PM
formula to only calculate the last 15 entries? April Excel Programming 2 July 18th 05 11:55 PM
Any way to calculate an average for more than 30 entries? torin_drake Excel Worksheet Functions 1 February 16th 05 01:59 PM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"