ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can you calculate delta time using different entries (https://www.excelbanter.com/excel-programming/442847-re-can-you-calculate-delta-time-using-different-entries.html)

Mike H

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.



All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com