formula for calculating time

[john sullivan]

If I have a value of time in column A such as 01:01
(meaning start time is 1 minute and 1 second) and column
B has a value of time such as 04:25 (meaning a stop time
of 4 minutes and 25 seconds), what is the formula to
subtract A from B so that results will be the time that
has elapsed between the two values? Thank you.

 

[macropod]

Hi John,

If the time data have been entered as time values, rather
than as text formatted to look like time values, then B#-
A# would suffice (where # represents the row number).

If, however, the times have been entered as text, things
would be much more complicated.

Cheers
PS: Remove NO.SPAM from the above before replying.

 

[David McRitchie]

Hi John,
Simply subtract the one from the other. Note the times you
entered are actually hours and minutes. As long as you don't
do additional calculations you may not see the difference.
Format as [h]:mm to keep the "hours" from
overflowing into days.

More information on date and time in
http://www.mvps.org/dmcritchie/excel/datetime.htm
--