Count minutes between two time/date fields
If your cells are formated with a date/time format:
=MINUTE(B2)-MINUTE(A2)
If they are formatted as text (and the dates are always the same length):
=MID(B2,16,2)-MID(A2,16,2)
These formulas assume a start date/time in A2 and an end date/time in B2,
adjust as needed.
"safetymast" wrote:
Does anyone have a formula they can give me to count the minutes between the
two columns below?
Dec.19.2007 21:36:23 Dec.19.2007 21:41:07
|