excel 2000
Posted by tina on November 10, 2001 5:43 PM
hi i would like to know how to get the differents between to times i have a start time in one colounn and an end time in the next i would like to be able to have the min between these two times in the next coloun how would i go about it thank you very much in advance
Posted by Jua Pablo on November 10, 2001 6:00 PM
Just use the formula
=B2 - A2
(If starting column is A and end column is B) and custom format as [mm]:ss
Juan Pablo
Posted by Juan Pablo on November 10, 2001 6:06 PM
Or..
=(B16-A16)*1440
To get the result as Number, not as a "date" value..
Juan Pablo
PS. Damned IE autocomplete !! "Jua Pablo" !!!
