View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default 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