MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Computations with dates


Posted by coline on September 21, 2001 3:57 PM

Hi, I would like to subtract a start time by an end time to find time in minutes. Currently my data are in the following form:
Start Time End Time
1650 1729

How to subtract so that I can work with a scale of 60 rather than 100? (So that my computation = 39 minutes and not 79)
Thanks!


Posted by coline on September 21, 2001 4:07 PM

Hi, again, I should have read the reader board before posting my request! The solution for the question before mine is the same one that I needed. Thanks!
C